Mcp Sqlite Manager
What is Mcp Sqlite Manager
mcp-sqlite-manager is an MCP server designed to interact with SQLite databases, allowing users to easily query, update, and inspect SQLite data using structured tools.
Use cases
Use cases include querying data for reports, updating records in applications, creating new database tables for new features, and inspecting database schemas for maintenance.
How to use
To use mcp-sqlite-manager, install it via pipx with the command ‘pipx install --force mcp-sqlite-manager’. For integration with Cursor, add the server configuration to your ‘~/.cursor/mcp.json’ file.
Key features
Key features include executing SELECT queries and returning results as JSON, performing INSERT, UPDATE, or DELETE operations, creating new tables, listing all tables in the database, and showing schema information for specific tables.
Where to use
mcp-sqlite-manager can be used in various fields such as data analysis, application development, and database management, where SQLite databases are utilized.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Mcp Sqlite Manager
mcp-sqlite-manager is an MCP server designed to interact with SQLite databases, allowing users to easily query, update, and inspect SQLite data using structured tools.
Use cases
Use cases include querying data for reports, updating records in applications, creating new database tables for new features, and inspecting database schemas for maintenance.
How to use
To use mcp-sqlite-manager, install it via pipx with the command ‘pipx install --force mcp-sqlite-manager’. For integration with Cursor, add the server configuration to your ‘~/.cursor/mcp.json’ file.
Key features
Key features include executing SELECT queries and returning results as JSON, performing INSERT, UPDATE, or DELETE operations, creating new tables, listing all tables in the database, and showing schema information for specific tables.
Where to use
mcp-sqlite-manager can be used in various fields such as data analysis, application development, and database management, where SQLite databases are utilized.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
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 aSELECTquery and return results as JSON.write_query: ExecuteINSERT,UPDATE, orDELETEqueries.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 (likePRAGMA 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.
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
