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

FAQ from mcp-sqlite-manager

How do I install mcp-sqlite-manager?

It is installed with pipx: pipx install --force mcp-sqlite-manager. (pipx requires Python to be available on your system.)

How do I integrate mcp-sqlite-manager with Cursor?

Add the following entry to your ~/.cursor/mcp.json file: {"mcpServers": {"mcp-sqlite-manager": {"command": "mcp-sqlite-manager"}}}.

What tools does mcp-sqlite-manager provide?

It provides five tools: read_query, write_query, create_table, list_tables, and describe_table. Each performs a specific SQLite operation.

What is the license of mcp-sqlite-manager?

The project is licensed under MIT, allowing free use, modification, and distribution.

Who created mcp-sqlite-manager?

It was created by Jonathan Hoffman (GitHub: jonnyhoff).