Ollama is popular because it makes running large language models (LLMs) locally simple, private, and inexpensive. DBeaver 26.2.5, also free & open-source, recently added support for Ollama. And both pair well with PostgreSQL.
Why Ollama Is Popular?
Runs AI Locally — Execute models such as Llama, Qwen, Gemma, and DeepSeek on your own computer without relying on cloud services.
Privacy and Data Control — Prompts and data can remain entirely on your machine, making Ollama attractive for sensitive business information and internal applications.
Free and Open Source — Ollama is free to use locally, with no per-token API charges. Individual models have their own licenses.
Easy Installation — Download and run models with simple commands:
ollama run llama3.2Developer-Friendly API — Provides a local REST API compatible with many AI development tools, making integration with Python, applications, and databases straightforward.
Broad Model Support — Supports numerous open-weight models, allowing developers to experiment with different capabilities, sizes, and performance characteristics.
Works Offline — Once models are downloaded, inference can run without an internet connection.
Hardware Flexibility — Runs on macOS, Linux, and Windows, supporting CPU inference and GPU acceleration on compatible hardware.
Why Developers Especially Like It
Ollama removes much of the complexity traditionally associated with deploying LLMs. Developers can prototype AI applications, build RAG systems, experiment with AI agents, and implement natural-language-to-SQL interfaces without managing complicated inference infrastructure.
Bottom Line
Ollama has become popular because it makes local AI accessible. It provides a straightforward way to download, run, and integrate powerful language models while retaining control over data, infrastructure, and costs.
For database developers, its biggest attraction is the ability to connect an LLM to database schemas and metadata, enabling the development of AI-assisted SQL applications without sending that information to an external AI provider.
DBeaver Community 26.2.5 added Ollama support, and now you can take your first steps.
Installation
I am using Ubuntu and installing Ollama is as you expect, pretty simple.
$curl -fsSL https://ollama.com/install.sh | sh
$ollama
![]() |
| First try at running Ollama |
![]() |
| I selected the gemma4:12b model |
![]() |
| Confirm the download |
![]() |
| Ollama is ready to go. |
DBeaver
![]() |
| Windows -> Preferences -> AI -> Model configuration |
![]() |
| Scroll for Ollama |
![]() |
| Pick the model by clicking on the two blue arrows. |
![]() |
| We have connected to the model |
![]() |
| Test the connection |
First Step
![]() |
| The first prompt |
![]() |
| Double-check the LLM and the model |
Now we can watch Ollama work with the database.
![]() |
| The first response |
![]() |
| Information about views |
Have The AI Write SQL
| Run, Edit, or Copy |
Here is an easier-to-read version of the query.
SELECT
f.title,
SUM(p.amount) AS total_revenue
FROM public.payment p
JOIN public.rental r ON p.rental_id = r.rental_id
JOIN public.inventory i ON r.inventory_id = i.inventory_id
JOIN public.film f ON i.film_id = f.film_id
GROUP BY f.title
ORDER BY total_revenue DESC
LIMIT 5;
![]() |
| The Top five titles by revenue |





















