Advertise
MCP.so
Sign In

MCPDatabases MCP Server

@alvnavraii

Repository

Basic information

Category

Other

Transports

stdio

Author

alvnavraii

Submitted by

rafael alvarez

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

MCPDatabases MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

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.

Frequently asked questions

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

Comments

More Other MCP servers

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

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

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K
Advertise