广告合作
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).

评论

其他 分类下的更多 MCP 服务器

der die das – German noun genders (Lingviko)

Lingviko

The article (der, die, das) of 90,000 German nouns, compounds included, plus a checker that finds wrong articles in German text (“mit der Zug” → dem). Uses dictionary data, not AI guessing. Free, no login.

Health by Dr Brad

Dr Brad Stanfield

Health by Dr Brad works out a health plan from your own results: which screening is due at your age, and evidence-based suggestions, each with the reason and the published guideline or study behind it. Your record is one

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K
广告合作