Wgong Sqlite Mcp Server
A FastMCP-based server that gives Claude direct access to SQLite databases through three tools: list_tables to enumerate available tables, describe_table to inspect schemas, and read_query to run SELECT statements. Point it at any SQLite file via the SQLITE_DB_PATH environment variable and you can ask questions like "what tables exist" or "show me transactions over $1000" without writing raw SQL yourself. Built for local exploration and quick database inspection, though it also supports remote deployment via Smithery's streamable HTTP transport. Useful when you need to poke around an unfamiliar SQLite database or let Claude help analyze local data without building a custom query interface.
- GitHub stars
- 1
- tools
- 3
- auth
- Required
- transport
- HTTP
- last updated
- Oct 5, 2025
Tools
3 toolsPublic tool metadata for what this MCP can expose to an agent.
list_tablesto see what tables are in your database
to see what tables are in your database
No parameter schema in public metadata yet.
describe_tableto see the structure of a specific table
to see the structure of a specific table
No parameter schema in public metadata yet.
read_queryto run SELECT queries on your data
to run SELECT queries on your data
No parameter schema in public metadata yet.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageReadme
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
Details
- Repository
- github.com/wgong/sqlite-mcp-server
- Category
- Databases
- Transport
- HTTP
- Auth
- Required
- Registry
- MCP registry, active
Related Databases MCP servers
View all
Mcp Encrypted Sqliterosch100/mcp-encrypted-sqliteMCP server for encrypted SQLite databases (SQLCipher 4) - Works with MoneyMoney, KeePass and more0stars
Microsoft Access Databaseunmateria/mcp-accessRead and edit Microsoft Access databases (.accdb/.mdb) - forms, VBA, tables, queries. Windows.61stars
Neo4j Mcp Canaryneo4j-labs/neo4j-mcp-canaryNeo4j MCP Canary — The canary goes first so the rest of us know what's coming3stars