MCP Sqlite Manager

What is mcp-sqlite-manager?

mcp-sqlite-manager is an MCP (Model Context Protocol) server built with FastMCP that enables interaction with SQLite databases through structured tools. It allows users to query, update, and inspect SQLite data using a set of predefined functions, primarily designed for integration with MCP clients like Cursor.

How to use mcp-sqlite-manager?

Install the package globally using pipx (pipx install --force mcp-sqlite-manager), then configure it as an MCP tool in Cursor by adding the command mcp-sqlite-manager to ~/.cursor/mcp.json. Once connected, you can call its five tools: read_query, write_query, create_table, list_tables, and describe_table.

Key features of mcp-sqlite-manager

• read_query: Execute SELECT queries and return JSON results
• write_query: Run INSERT, UPDATE, or DELETE statements
• create_table: Create new tables from SQL schema definitions
• list_tables: List all tables in the connected database
• describe_table: Show schema info via PRAGMA table_info

Use cases of mcp-sqlite-manager

• Query an SQLite database and retrieve results as structured data
• Insert, update, or delete records without manual SQL execution
• Create new database tables programmatically through MCP tools
• Explore and list all tables in an existing SQLite database
• Inspect table schemas to understand column types and constraints