mcpDataBases

mcpDataBases

0
databases

The DataBase Project manages and migrates data between PostgreSQL and SQLite, offering an MCP server for CRUD operations and table management. It simplifies data transfers and provides advanced query capabilities.

🗄️ DataBase Project (PostgreSQL & SQLite Management)

This project manages and migrates data between PostgreSQL and SQLite databases. It facilitates CRUD operations and administration for applications needing flexibility between database engines.

📁 Main Structure

  • MCP server for database queries and table modifications
  • Connection management for PostgreSQL
  • Script for data migration from PostgreSQL to SQLite

⚙️ Features

  • CRUD operations for PostgreSQL
  • Table management features
  • Automatic data migration between PostgreSQL and SQLite
  • Custom SQL queries for analysis and maintenance

🚀 Usage Examples

  • Run the MCP server using main.py for various database actions.
  • Use migration scripts to transfer data from PostgreSQL to SQLite.

📊 MCP Configuration

Details on configuration with mcp_config.json for enabling MCP tools across environments.

📈 Dependencies

  • Python 3.8+
  • psycopg2-binary
  • sqlite3
  • PostgreSQL server and database

📝 Notes

Configure mcp_config.json and connection.py for proper setup. Restart MCP server after database structure changes.