Afgong Sqlite Mcp Server
This server gives Claude direct access to SQLite databases through three core operations: listing tables, inspecting schemas, and running SELECT queries. Built with FastMCP, it exposes read-only database exploration tools that let you interrogate table structures and query data without writing custom integration code. You'd reach for this when you want Claude to analyze SQLite databases during conversations, whether that's exploring a Messages database, financial records, or any other SQLite file. The server runs locally or deploys to Smithery's platform, and configuration just requires setting the SQLITE_DB_PATH environment variable to point at your database file. Great for ad-hoc database analysis without building separate query interfaces.
- tools
- 3
- auth
- Required
- transport
- HTTP
- last updated
- Oct 2, 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/afgong/sqlite-mcp-server
- Category
- Databases
- Transport
- HTTP
- Auth
- Required
- Registry
- MCP registry, active
Related Databases MCP servers
View all
Mongo Scout Mcpbluwork/mongo-scout-mcpScout your MongoDB databases with AI - safety features, live monitoring, and data quality0stars
MySQL MCP Servermusaddiq-dev/mysql-mcp-serverPython MCP server for MySQL database inspection and querying0stars
Supabase Rls Checktthanh2k6/supabase-rls-checkRead-only Supabase RLS checks: explain rules, analyze/diff SQL exports, scan public env vars.0stars
Postgres MCP Procrystaldba/postgres-mcpPostgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.2.8Kstars
MySQLdesigncomputer/mysql_mcp_serverA Model Context Protocol (MCP) server that enables secure interaction with MySQL databases1.3Kstars
ClickHouseclickhouse/mcp-clickhouseOfficial ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.903stars