MCPDatabases MCP Server

@alvnavraii

リポジトリ

基本情報

カテゴリ

その他

トランスポート

stdio

作者

alvnavraii

投稿者

rafael alvarez

MCPDatabases MCP Server について

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

#database #postgresql #sqlite #server

MCPDatabases MCP Server の設定

以下の設定を使って、このサーバーを 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"
      ]
    }
  }
}

MCPDatabases MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは 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.

よくある質問

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](https://github.com/alvnavraii/mcpDataBasesSSE).

「その他」の他のコンテンツ

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi