📦

Local Analyst

Talk to your data locally 💬📊. A private AI Data Analyst built with the Model Context Protocol (MCP), Ollama, and SQLite. Turn natural language into SQL queries without data leaving your machine. Includes a Dockerized Streamlit UI

0 installs

6 stars

4 forks

Trust: 56 — Fair

Ai

Installation

npx mcp-local-analyst

Ask AI about Local Analyst

Powered by Claude · Grounded in docs

I know everything about Local Analyst. Ask me about installation, configuration, usage, or troubleshooting.

0/500

Documentation

MCP Local Analyst

Demo

Talk to your data locally 💬📊. A private AI Data Analyst built with the Model Context Protocol (MCP), Ollama, and SQLite. Turn natural language into SQL queries without data leaving your machine. Includes a Dockerized Streamlit UI

📝 Read the full article on Medium

Getting Started

Prerequisites

Before running the application, make sure you have the following installed:

Docker & Docker Compose - Required for running the application in containers
- Install Docker Desktop from docker.com
- Includes Docker Compose by default
Ollama - For running local LLM models
- Download from ollama.ai
- After installation, pull a model: ollama pull mistral (or your preferred model)
- Ollama will run as a service on http://localhost:11434

Installation & Running Locally

Clone the repository
Ensure Ollama is running:
```
ollama serve
```
(Keep this running in a separate terminal)
Start the application with Docker Compose:
```
docker-compose up --build
```
Open your browser and navigate to:
```
http://localhost:8501
```

Configuration

Modify the database by editing src/seed_data.py if needed
Configure model selection and parameters in the application UI
Data is stored in the data/ directory