ai.smithery/wgong-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
fastm

... [View full README on GitHub](https://github.com/wgong/sqlite-mcp-server#readme)