Mcpdatabases

This project is a database management tool that supports data migration and CRUD operations between PostgreSQL and SQLite, providing table structure management and advanced query functions.

Database Developer tools #Database Migration #CRUD Operations #Table Management #Multi - Engine .Python

rating : 2 points

downloads : 6

update time : 2025-04-29

What is the MCP Database Management Server?

The MCP Database Management Server is a tool integrating multiple functions, aiming to simplify data migration, table operations, and query execution between PostgreSQL and SQLite databases. It supports common CRUD operations (Create, Read, Update, Delete) and allows users to easily manage database structures.

How to use the MCP Database Management Server?

You can start the server through simple command - line operations, and then perform database management tasks as needed, such as querying, inserting, modifying, or deleting data.

Applicable scenarios

Suitable for application developers who need to seamlessly switch between different database engines, especially in scenarios involving PostgreSQL and SQLite.

Main Features

CRUD OperationsSupports adding, deleting, modifying, and querying records in the database, such as inserting new data, updating existing records, or deleting unnecessary data.

Data MigrationCan migrate all tables and their data from a PostgreSQL database to an SQLite database, and vice versa.

Table ManagementEasily create, modify, or delete table structures in the database.

Advanced Query ExecutionSupports running complex custom SQL queries to meet data analysis needs.

Advantages and Limitations

Advantages

Supports seamless switching between multiple database engines.

Provides powerful query tools for easy data analysis.

Easy to configure and quickly deploy.

Open - source and free to use.

Limitations

Requires certain database knowledge to fully utilize its functions.

May not support some advanced database features.

Depends on the installation and configuration of the local environment.

How to Use

Install and Configure the Environment

Ensure that Python 3.8+ is installed and the connection information for PostgreSQL and SQLite databases is set up.

Start the MCP Server

Run the main script to start the MCP server.

Execute Common Commands

Use built - in tools to perform various database management tasks.

Usage Examples

Create a New UserAdd a new user record to the database.

Query Active ProductsRetrieve all active products.

Frequently Asked Questions

How to start using the MCP Database Management Server?

Does it support other types of databases?

How to solve the connection failure problem?

Related Resources

Official Documentation

Get more information about the MCP Database Management Server.

GitHub Code Repository

Access the project's source code and contribution guidelines.

Example Configuration File

Download the MCP configuration file template.

🚀 Database Project (PostgreSQL and SQLite Management)

This project aims to manage and migrate data between PostgreSQL and SQLite databases, making CRUD operations and database management for applications more flexible.

⚠️ Important Note

Another version of this project supports Server-Sent Events (SSE). See mcpDataBasesSSE on GitHub.

✨ Features

CRUD Operations: ➕ Create, 🔍 query, ✏️ update, and ❌ delete records in PostgreSQL database tables.
Table Management: 🏗️ Easily create, 🛠️ modify, and 🗑️ delete tables.
Data Migration: 🔄 Automatically transfer structures and data to SQLite or other databases.
Advanced Queries: 🧮 Execute custom SQL queries for analysis or maintenance.

📦 Installation

This README doesn't provide specific installation steps, so this section is skipped.

💻 Usage Examples

Basic Usage

1. MCP Server (`main.py`)

Run the MCP server to access database management tools:

python3 main.py

Available tools include:

🔎 query_db(query): Execute a SELECT query and return the results.
➕ insert_db(query): Execute an INSERT statement.
✏️ update_db(query): Execute an UPDATE statement.
❌ delete_db(query): Execute a DELETE statement.
🛠️ modify_table(): Modify the database table structure.

2. Data Migration (`migrate_postgres_to_sqlite.py`)

Run the script to migrate data:

python3 migrate_postgres_to_sqlite.py

Ensure that you configure the connection parameters before running.

📚 Documentation

📁 Main Structure

main.py: 🖥️ Provides MCP server tools for querying, inserting, updating, deleting, and modifying PostgreSQL database tables.
connection.py: 🔗 Manages PostgreSQL database connections.
migrate_postgres_to_sqlite.py: 🔄 A script for migrating all PostgreSQL tables and their data to SQLite.
ecommerce.db: 🗃️ An SQLite database generated by migration (optional).

⚖️ Precautions

When configuring the MCP service, refer to the examples and specify the correct paths and parameters in mcp_config.json (or claude_desktop_config.json).
After modifying the database structure, restart the MCP server to avoid connection issues.
Adjust the script as needed to support other databases or additional features.

This project is a comprehensive toolset for PostgreSQL and SQLite database management. After installing and configuring the environment according to the steps in the README, you can easily perform database operations and migrations.