広告掲載
MCP.so
ログイン

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.

よくある質問

1

What Python version is required?

Python 3.8 or higher is required.

2

What dependencies are needed?

The server requires `psycopg2-binary`, the built-in `sqlite3` module, and a running PostgreSQL server with a configured database.

3

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`.

4

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.

5

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).

コメント

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

Codelf

unbug

A search tool helps dev to solve the naming things problem.

14.2K

Awesome Mlops

visenger

A curated list of references for MLOps

14.0K

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K
P

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

広告掲載