Afgong Sqlite Mcp Server
Let your agent browse schemas, list tables, and run flexible SQL against your local Apple Messages SQLite database for debugging, exports, or personal automation experiments.
Overview
ai.smithery/afgong-sqlite-mcp-server is an MCP server for the Build phase that lets agents explore and query a local Messages SQLite database via schema-aware tools.
What is this MCP server?
- Explore Messages SQLite: browse tables and inspect schemas
- Run flexible queries through MCP tools (FastMCP-based server)
- Smithery streamable HTTP remote with Bearer authentication (v1.16.0)
- Source repo afgong/sqlite-mcp-server (sqlite-explorer-fastmcp-mcp-server subfolder)
- Local-database focus—not a hosted warehouse or ORM generator
- Server version 1.16.0 in published server metadata
- GitHub repository afgong/sqlite-mcp-server with sqlite-explorer-fastmcp-mcp-server subfolder
- Smithery remote type streamable-http
What problem does it solve?
Inspecting Apple Messages SQLite by hand is slow and error-prone when you want an agent to reason over tables and run ad hoc SQL safely.
Who is it for?
Solo builders on macOS experimenting with message archives, personal analytics, or SQLite-backed agent tooling.
Skip if: Production customer inboxes, team-wide CRM, or regulated PHI workflows without explicit access controls and legal review.
What do I get? / Deliverables
After MCP registration, your agent can list tables, inspect schemas, and run flexible queries against the configured SQLite file from the chat thread.
- Table listings and schema descriptions from the SQLite file
- Query results returned into the agent session for analysis or codegen
- Clearer picture of columns and relationships before you ship export scripts
Recommended MCP Servers
Journey fit
This is a local data integration you add while building or extending agent tooling around real on-disk SQLite. Fits integrations because it connects the agent to a specific SQLite datastore rather than replacing app frontend or ship-time QA.
How it compares
Local SQLite explorer MCP, not a hosted Postgres admin or a data-pipeline ETL skill.
Common Questions / FAQ
Who is ai.smithery/afgong-sqlite-mcp-server for?
Developers who want their AI agent to browse and query a Messages SQLite database for personal projects, debugging, or prototyping integrations.
When should I use ai.smithery/afgong-sqlite-mcp-server?
Use it during build when you need schema discovery or exploratory SQL against a local SQLite Messages store before writing app or export code.
How do I add ai.smithery/afgong-sqlite-mcp-server to my agent?
Configure the Smithery remote for @afgong/sqlite-mcp-server with Bearer smithery_api_key in your MCP client and ensure the agent runtime can reach the database path your deployment expects.