The server exposes 7 tools, 3 resources, and 3 prompts over a normalized SQLite database (8 tables, 891 records). It supports both stdio transport for local Claude Desktop usage and HTTP transport for remote Docker deployments. The MCP Inspector provides an interactive web UI for testing every tool and resource before connecting an agent.
The server exposes 7 tools, 3 resources, and 3 prompts over a normalized SQLite database (8 tables, 891 records). It supports both stdio transport for local Claude Desktop usage and HTTP transport for remote Docker deployments. The MCP Inspector provides an interactive web UI for testing every tool and resource before connecting an agent.
Technical Highlights
- 7 MCP tools — query, aggregate, survival analysis, sandboxed SQL, and more
- 3 resources and 3 prompts for guided data exploration
- Human-readable output — automatic foreign key resolution, no raw IDs
- Dual transport — stdio for Claude Desktop, HTTP for remote/Docker
- MCP Inspector integration for interactive testing
- Normalized database schema with 8 tables and automatic JOINs
Stack
- Protocol: Model Context Protocol (MCP)
- Language: Python
- Database: SQLite (8 normalized tables)
- Deployment: Docker, stdio/HTTP transport
- Testing: MCP Inspector