Sqlite MCP Server

Prerequisites

# Install dependencies
pip install -r requirements.txt

# Install FastMCP globally (if not already installed)
pip install fastmcp

COMMAND CHEATSHEET

# Run FastMCP directly for testing
SQLITE_DB_PATH=/Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db fastmcp run sqlite_explorer.py

# Test with inspector (if available)
SQLITE_DB_PATH=/Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db fastmcp inspect sqlite_explorer.py

# To install SQLite Explorer
SQLITE_DB_PATH=/Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db fastmcp install sqlite_explorer.py --name "SQLite Explorer"

# To launch SQLite Explorer via a web-based testing interface. Run with `--transport sse` for HTTP-based communication  
SQLITE_DB_PATH=/Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db fastmcp dev sqlite_explorer.py

# To set up the MCP server with Claude Desktop
SQLITE_DB_PATH=/Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db fastmcp claude-desktop add sqlite_explorer.py --name "SQLite Explorer"

# Need to define the SQLITE_DB_PATH variable before running smithery playground 
SQLITE_DB_PATH=/Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db smithery playground

After launching Smithery playground, we can now talk to the MCP server using this URL: https://smithery.ai/playground?mcp=https%3A%2F%2Fee09cd8f.ngrok.smithery.ai%2Fmcp

For VSCode with Cline

# Add this configuration to Cline MCP settings:
{
  "sqlite-explorer": {
    "command": "uv",
    "args": [
      "run",
      "--with",
      "fastmcp",
      "--with",
      "uvicorn",
      "fastmcp",
      "run",
      "/Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/sqlite_explorer.py"
    ],
    "env": {
      "SQLITE_DB_PATH": "/Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db"
    }
  }
}

Example output. MCP server provides four components. SQLite Explorer provides those tools.

Server Name: SQLite Explorer Generation: 2

Components Tools: 3 Prompts: 0 Resources: 0 Templates: 0

Environment FastMCP: 2.12.4 MCP: 1.15.0

This will open an interactive inspector where you can test the MCP tools:

• list_tables - to see what tables are in your database
• describe_table - to see the structure of a specific table
• read_query - to run SELECT queries on your data

Notes

Even though we're running the MCP locally, still have a web interface For locally deployed MCP server SQLite Explorer, this is the MCP server URL that we can access as a client: http://localhost:6274/?MCP_PROXY_AUTH_TOKEN=e01acfa4461c1af5227669c2c0051e7cf9c280fb61a43a146a672463441f4c1b#tools In the future, once deployed, we'll have the same thing - HTTP or HTTPS, but instead of a local host, it'll be my server and the port. The rest will be something else. Local host is the server name, so the server is a local host. But if deployed somewhere, then it'll be a different host name. The port serves as a channel to talk to multiple MCP servers. HTTPS is a secure HTTP.

Sample Questions to Ask Your AI Assistant

Once the MCP server is connected, you can ask questions like:

• "What tables are in my database?"
• "Show me the structure of my financial data"
• "What are the first 10 rows from [table_name]?"
• "How many records are in each table?"
• "Show me all transactions over $1000"
• "What's the average amount in the transactions table?"

NOTE: The tables starting with SQLite are called system tables. We never created those tables.

Troubleshooting

# Check FastMCP version and available commands
fastmcp --help
fastmcp version

# Verify your database file exists
ls -la /Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db

# Test database directly with sqlite3
sqlite3 /Users/owner/claude-code/agentic-ai-learnings/hw3/sqlite-explorer-fastmcp-mcp-server/financial_data.db ".tables"

HW 3 Documentation

Step 1

Cloned this GitHub repository: https://github.com/hannesrudolph/sqlite-explorer-fastmcp-mcp-server

Step 2

Asked Claude Code: I was asked to evaluate the following deployment platforms: AWS, Vercel, Railway, and Smithery for my MCP server. I want the simplest and cheapest deployment. Which option should I select?

⏺ Based on your MCP server and requirements, I recommend Smithery.

Here's why:

Simplest: Smithery is specifically designed for MCP servers. It has the most straightforward deployment process for this exact use case.

Cheapest: Smithery offers a free tier for MCP server hosting, making it the most cost-effective option for your SQLite Explorer MCP server.

Other options comparison:

• AWS: Most complex setup, requires managing infrastructure, not cost-effective for simple MCP servers
• Vercel: Designed for web apps/APIs, not optimized for MCP servers, serverless model may not fit well
• Railway: Good platform but more expensive than Smithery's free tier, more general-purpose

For a read-only SQLite MCP server like yours, Smithery's MCP-specific infrastructure is the best match for "simplest and cheapest."

Step 3

Tested this locally via Cline. In VS Code, we configured the system settings to launch a web-based interface with the following JSON file. See URL: http://localhost:6274/?MCP_PROXY_AUTH_TOKEN=a164e503687338cb23938baf05ae738ebe5cd0eaefa629e419cea7ef6ef51563#tools

Step 4