MCP Sqlite Manager

🚀 mcp-sqlite-manager

An MCP server built with FastMCP for interacting with SQLite databases. Effortlessly query, update, and inspect SQLite data using structured tools.

🚀 Quick Start

This project is an MCP server built with FastMCP, which enables seamless interaction with SQLite databases. You can perform various operations on SQLite data through structured tools.

✨ Features

• read_query: Execute SELECT queries and return results in JSON format.
• write_query: Execute INSERT, UPDATE, or DELETE queries.
• create_table: Create a new table using a SQL schema definition.
• list_tables: Return a list of all tables in the database.
• describe_table: Display schema information for a specific table (similar to PRAGMA table_info).

📦 Installation

🐍 Using pipx

This package is designed to be installed using pipx(opens new window), which allows you to run Python applications in an isolated environment.

pipx install --force mcp-sqlite-manager

🔌 MCP Integration in Cursor

To use this server as an MCP tool in Cursor, add the following configuration to the ~/.cursor/mcp.json file or configure it through the Cursor settings menu.

{
    "mcpServers": {
        "mcp-sqlite-manager": {
            "command": "mcp-sqlite-manager"
        }
    }
}

🧑‍💻 Author

Jonathan Hoffman GitHub LinkedIn

Proficient in: Python, Django, JS, Web, ML, AI, coffee, and 🍺 beer.

📄 License

MIT —— Free to use, modify, and improve.