# Mcp 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

- **Type:** MCP server
- **Install:** `agentstack add mcp-fabiothiroki-mcp-local-analyst`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [fabiothiroki](https://agentstack.voostack.com/s/fabiothiroki)
- **Installs:** 0
- **Category:** [Databases](https://agentstack.voostack.com/c/databases)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [fabiothiroki](https://github.com/fabiothiroki)
- **Source:** https://github.com/fabiothiroki/mcp-local-analyst

## Install

```sh
agentstack add mcp-fabiothiroki-mcp-local-analyst
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# MCP 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

📝 **[Read the full article on Medium](https://medium.com/gitconnected/chat-with-your-database-for-free-build-a-private-ai-agent-in-python-87bc0245ca8f)**

## Getting Started

### Prerequisites

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

1. **Docker & Docker Compose** - Required for running the application in containers
   - Install Docker Desktop from [docker.com](https://www.docker.com/products/docker-desktop)
   - Includes Docker Compose by default

2. **Ollama** - For running local LLM models
   - Download from [ollama.ai](https://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

1. Clone the repository

2. Ensure Ollama is running:
   ```bash
   ollama serve
   ```
   (Keep this running in a separate terminal)

3. Start the application with Docker Compose:
   ```bash
   docker-compose up --build
   ```

4. 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

## Source & license

This open-source MCP server is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [fabiothiroki](https://github.com/fabiothiroki)
- **Source:** [fabiothiroki/mcp-local-analyst](https://github.com/fabiothiroki/mcp-local-analyst)
- **License:** MIT

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/mcp-fabiothiroki-mcp-local-analyst
- Seller: https://agentstack.voostack.com/s/fabiothiroki
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.