mcpField
M
mcp-sqlite-manager

mcp-sqlite-manager

Local
github.com/jonnyhoffDatabases3Updated 80w ago
Repository

About mcp-sqlite-manager

mcp-sqlite-manager is a FastMCP server for querying and managing SQLite databases through structured tools. It supports data changes as well as table inspection for AI clients.

Key features

  1. 01Run SELECT queries with JSON results
  2. 02Run INSERT, UPDATE, and DELETE
  3. 03Create tables from SQL schemas
  4. 04List database tables
  5. 05Inspect a table's schema

Use cases

  1. 01Query SQLite data and read JSON results
  2. 02Insert, update, or delete database records
  3. 03Create tables and inspect existing schemas

MCP support

The server exposes SQLite query, write, and schema-management tools to MCP clients.

#mcp-sqlite-manager#database#sqlite

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

No install method listed yet

We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.

Repository

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

mcp-sqlite-manager

An MCP server built with FastMCP to interact with SQLite databases. Easily query, update, and inspect SQLite data using structured tools.

🚀 Features

  • read_query: Execute a SELECT query and return results as JSON.
  • write_query: Execute INSERT, UPDATE, or DELETE queries.
  • create_table: Create new tables using SQL schema definitions.
  • list_tables: Return a list of all tables in the database.
  • describe_table: Show schema info for a specific table (like PRAGMA table_info).

📦 Installation

🐍 With pipx

This package is designed to be installed with pipx, which allows you to run Python applications in isolated environments.

pipx install --force mcp-sqlite-manager
🔌 MCP Integration in Cursor

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

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

🧑‍💻 Author

Jonathan Hoffman GitHub LinkedIn

🐍 Python, Django, JS, Web, ML, AI, coffee and 🍺 beer.

📄 License

MIT – free to use, hack, and improve.

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.