Ollama MCP Database Assistant

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:

1. Install dependencies:

1. Pull the required Ollama model:

1. Create a .env file in the project root:

Usage

1. Start the chat interface:

1. Ask questions about your data in natural language:

1. 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:

Environment Variables

Security

• All database access is read-only

• SQL queries are restricted to SELECT statements

• Database credentials are kept secure in your .env file

Development

• TypeScript

• Model Context Protocol (MCP)

• Ollama

• PostgreSQL

Troubleshooting

Common Issues

1. "Failed to connect to database"

2. "Failed to connect to Ollama"

3. "Error executing query"

License

Contributing

1. Fork the repository

2. Create your feature branch

3. Commit your changes

4. Push to the branch

5. Open a Pull Request

Ollama MCP Database Assistant

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:

1. Install dependencies:

1. Pull the required Ollama model:

1. Create a .env file in the project root:

Usage

1. Start the chat interface:

1. Ask questions about your data in natural language:

1. 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:

Environment Variables

Security

• All database access is read-only

• SQL queries are restricted to SELECT statements

• Database credentials are kept secure in your .env file

Development

• TypeScript

• Model Context Protocol (MCP)

• Ollama

• PostgreSQL

Troubleshooting

Common Issues

1. "Failed to connect to database"

2. "Failed to connect to Ollama"

3. "Error executing query"

License

Contributing

1. Fork the repository

2. Create your feature branch

3. Commit your changes

4. Push to the branch

5. Open a Pull Request