{"repo":"robdodson/ollama-mcp-db","free":true,"listed":false,"github":"https://github.com/robdodson/ollama-mcp-db","clone":"git clone https://github.com/robdodson/ollama-mcp-db.git","description":"An interactive chat interface that combines Ollama's LLM capabilities with PostgreSQL database access through the Model Context Protocol (MCP).","language":"TypeScript","stars":62,"topics":[],"license":null,"category":"mcp-servers","readme_excerpt":"Ollama MCP Database Assistant 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. Features - Natural language interface to your PostgreSQL database - Automatic SQL query generation - Schema-aware responses - Interactive chat interface - Secure, read-only database access Prerequisites - Node.js 16 or higher - A running PostgreSQL database - Ollama installed and running locally - The qwen2.5-coder:7b-instruct model pulled in Ollama Setup 1. Clone the repository: 2. Install dependencies: 3. Pull the required Ollama model: 4. Create a .env file in the project root: Usage 1. Start the chat interface: 2. Ask questions about your data in natural language: 3. Type 'exit' to quit the application. How It Works 1. The application connects to your PostgreSQL database through the PostgreSQL MCP server 2. It loads and caches your database schema 3. When you ask a question: - The schema and question are sent to Ollama - Ollama generates an appropriate SQL query - The query is executed through MCP - Results are sent back to Ollama for interpretation - You receive a natural language response Environment Variables Variable Description Default ------------ ---------------------------- ------------------------- DATABASE URL PostgreSQL connection string Required OLLAMA MODEL Ollama model to use qwen2.","default_branch":null,"files":null,"tree":[],"storefront":"/r/robdodson","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/robdodson/ollama-mcp-db/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}