MCPDatabases
@alvnavraii
About MCPDatabases
MCP Server to manage PostGress and SQLite. In fact, you could use any Database Engine
Basic information
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"SqliteManagement": {
"command": "/home/slendy/MCPProjects/DataBase/.venv/bin/python",
"args": [
"/home/slendy/MCPProjects/DataBase/main.py",
"--engine",
"sqlite",
"--url",
"sqlite:////home/slendy/MCPProjects/DataBase/ecommerce.db"
]
},
"PostgressManagement": {
"command": "/home/slendy/MCPProjects/DataBase/.venv/bin/python",
"args": [
"/home/slendy/MCPProjects/DataBase/main.py",
"--engine",
"postgresql",
"--url",
"postgresql://postgres:postgres@localhost:5433/ecommerce"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is MCPDatabases?
MCPDatabases is an MCP server that manages PostgreSQL and SQLite databases, enabling CRUD operations, table management, and data migration between the two engines. It is intended for applications that need flexibility across PostgreSQL and SQLite.
How to use MCPDatabases?
Run the MCP server with python3 main.py. Configure services in mcp_config.json or claude_desktop_config.json using command, args with --engine and --url flags for each database engine. The server exposes tools for queries, inserts, updates, deletes, and table alterations.
Key features of MCPDatabases
- CRUD operations: create, read, update, delete records.
- Table management: create, alter, drop tables.
- Data migration between PostgreSQL and SQLite.
- Execute custom SQL queries for analysis.
Use cases of MCPDatabases
- Migrate all tables and data from a PostgreSQL database to SQLite.
- Perform administrative CRUD operations on a production PostgreSQL database via MCP tools.
- Manage multiple database engines (PostgreSQL and SQLite) from a single MCP configuration.
- Run ad‑hoc SELECT queries for reporting or maintenance.
FAQ from MCPDatabases
What Python version is required?
Python 3.8 or higher is required.
What dependencies are needed?
The server requires psycopg2-binary, the built-in sqlite3 module, and a running PostgreSQL server with a configured database.
How do I configure database credentials?
Set the --url argument with your database connection string (e.g., postgresql://user:password@localhost:5432/ecommerce). Do not include real passwords in the config file; replace user and password with the actual values. Also update credentials in connection.py.
Can I use a different PostgreSQL port?
Yes. The default port is 5432. You can specify another port (e.g., 5433) in the connection URL.
Is there an alternative version with SSE support?
Yes. An alternative version with Server‑Sent Events (SSE) support is available at mcpDataBasesSSE on GitHub.
More Other MCP servers
Nginx UI
0xJackyYet another WebUI for Nginx
MCP Go 🚀
mark3labsA Go implementation of the Model Context Protocol (MCP), enabling seamless integration between LLM applications and external data sources and tools.
Maestro
mobile-dev-incPainless E2E Automation for Mobile and Web
Inbox Zero AI
elie222The world's best AI personal assistant for email. Open source app to help you reach inbox zero fast.
🚀 Model Context Protocol (MCP) Curriculum for Beginners
microsoftThis open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,
Comments