How ccarrott/read-only-sqlite-mcp-server works
This is a read-only SQLite exploration server exposed to MCP clients over stdio. A client invokes table listing, table description, or bounded SQL-query tools; it can also request a live schema resource or an analysis prompt. FastMCP registration is the runtime entry point, and DatabaseManager performs database access while security checks enforce read-only behavior. The README documents these capabilities and safeguards; sampled source shows registration and database calls, but not every connection or serialization detail.
Main entry points: db.py Database Manager · server.py Stdio Server · tools.py Inspection Tools · resources.py Schema Resource
Components 8
MCP Runtime
- Stdio Server
src/sqlite_mcp/server.py
Safe Database Access
- Database Manager
src/sqlite_mcp/db.py - Query Safeguards
src/sqlite_mcp/security.py
Exploration Interfaces
- Inspection Tools
src/sqlite_mcp/tools.py - Schema Resource
src/sqlite_mcp/resources.py - Schema Prompt
src/sqlite_mcp/prompts.py
Other components
- MCP Client
- SQLite Database
Connections 9
- MCP Client → Stdio Server: connects via stdio
README.md - Stdio Server → Inspection Tools: registers tools
src/sqlite_mcp/server.py - Stdio Server → Schema Resource: registers resource
src/sqlite_mcp/server.py - Stdio Server → Schema Prompt: registers prompt
src/sqlite_mcp/server.py - Inspection Tools → Database Manager: calls database operations
src/sqlite_mcp/tools.py - Schema Resource → Database Manager: requests schema Markdown
src/sqlite_mcp/resources.py - Schema Prompt → Database Manager: requests schema Markdown
src/sqlite_mcp/prompts.py - Database Manager → Query Safeguards: uses SQL validation
src/sqlite_mcp/db.py - Database Manager → SQLite Database: reads schema and data
README.md