MCPDatabases

Name: MCPDatabases
Author: alvnavraii

@alvnavraii

代码仓库

关于 MCPDatabases

MCP Server to manage PostGress and SQLite. In fact, you could use any Database Engine

#database #postgresql #sqlite #server

基本信息

分类

其他

运行时

python

传输方式

stdio

发布者

alvnavraii

提交者

rafael alvarez

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "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"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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.