You: "Which customers have the highest lifetime value?"
        ↓
Claude calls summarise_data → understands your schema
        ↓
Claude calls query_data → generates and runs the SQL
        ↓
Claude explains the results in plain English

git clone https://github.com/yourusername/mcp-fi.git
cd mcp-fi

python -m venv venv
source venv/bin/activate        # Mac/Linux
venv\Scripts\activate           # Windows

pip install -r requirements.txt

cp config.example.json config.json

{
  "sources": {
    "my_sqlite_db": {
      "type": "sqlite",
      "path": "/absolute/path/to/your/database.sqlite"
    },
    "my_csv_data": {
      "type": "csv",
      "data_dir": "/absolute/path/to/your/csv/folder/"
    },
    "my_postgres": {
      "type": "postgres",
      "dsn": "postgresql://user:password@localhost/dbname"
    },
    "my_mysql": {
      "type": "mysql",
      "host": "localhost",
      "port": 3306,
      "database": "mydb",
      "user": "root",
      "password": "yourpassword"
    }
  }
}

open ~/Library/Application\ Support/Claude/claude_desktop_config.json

%APPDATA%\Claude\claude_desktop_config.json

{
  "mcpServers": {
    "mcp-fi": {
      "command": "/absolute/path/to/mcp-fi/venv/bin/python",
      "args": [
        "/absolute/path/to/mcp-fi/server.py"
      ],
      "cwd": "/absolute/path/to/mcp-fi"
    }
  }
}

What tables are available in my_sqlite_db?

Show me the top 10 customers by total orders from my_postgres

What is the average net worth by income level in my_csv_data?

Compare the users table between my_sqlite_db and my_postgres — are they in sync?

Which products in my_mysql have been ordered more than 100 times 
and what is their average rating?

pytest tests/ -v

pytest tests/test_sqlite_connector.py -v
pytest tests/test_csv_connector.py -v
pytest tests/test_postgres_connector.py -v
pytest tests/test_mysql_connector.py -v

npx @modelcontextprotocol/inspector python server.py

python server.py --sse --port 8000

web: python server.py --sse --port $PORT

https://mcp-fi-production.up.railway.app

{
  "mcpServers": {
    "mcp-fi": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-remote",
        "https://mcp-fi-production.up.railway.app/sse"
      ]
    }
  }
}

mcp-fi/
├── connectors/
│   ├── base_connector.py      # Abstract contract all connectors implement
│   ├── sqlite_connector.py    # SQLite support
│   ├── csv_connector.py       # CSV support via DuckDB
│   ├── postgres_connector.py  # PostgreSQL support
│   ├── mysql_connector.py     # MySQL support
│   └── router.py              # Routes source names to correct connector
├── tools/
│   ├── query_tool.py          # Run SQL against any source
│   ├── summarise_tool.py      # Describe table structure
│   └── compare_tool.py        # Diff two sources
├── tests/                     # 116 tests across all layers
├── data/                      # Put your SQLite and CSV files here
├── server.py                  # Entry point — stdio and SSE transport
├── config.json                # Your data sources (gitignored)
├── config.example.json        # Template for config.json
└── requirements.txt           # Python dependencies