Ollama Database Assistant MCP Server

Enables natural language querying of PostgreSQL databases using Ollama's LLM and the Model Context Protocol.

Local serverstdioTypeScript★ 62

What is the Ollama Database Assistant MCP Server?

Enables natural language querying of PostgreSQL databases using Ollama's LLM and the Model Context Protocol.

What it actually does

An interactive chat interface that combines Ollama's LLM capabilities with PostgreSQL database access through the Model Context Protocol (MCP). Ask questions about your data in natural language and get AI-powered responses backed by real SQL queries.

  • Natural language interface to your PostgreSQL database
  • Automatic SQL query generation
  • Schema-aware responses
  • Interactive chat interface
  • Secure, read-only database access

Configuration

  • Node.js 16 or higher - A running PostgreSQL database - Ollama installed and running locally - The qwen2.5-coder:7b-instruct model pulled in Ollama

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Configuration

  • Node.js 16 or higher - A running PostgreSQL database - Ollama installed and running locally - The qwen2.5-coder:7b-instruct model pulled in Ollama
VariableDescriptionRequired
DATABASE_URLEndpoint or connection string the server talks to.Yes

Frequently asked questions

You need Node.js 16 or higher, a running PostgreSQL database, Ollama installed and running locally, and the qwen2.5-coder:7b-instruct model pulled in Ollama.