mcpDataBasesSSE

mcpDataBasesSSE

0
databases

DataBaseSse Project is an advanced MCP server enabling efficient data management and migration between PostgreSQL and SQLite databases, featuring live updates via Server-Sent Events. It provides tools for CRUD operations and supports real-time notification of database changes.

🗄️ DataBaseSse Project (SSE Version)

This project is the SSE version of the original 'stido' release. It enhances data management and migration between PostgreSQL and SQLite databases with Server-Sent Events (SSE) support.

📁 Main Structure

  • Features tools for querying, inserting, updating, deleting, and modifying PostgreSQL databases with SSE.

⚙️ Features

  • CRUD operations for PostgreSQL tables
  • Table management (create, alter, drop)
  • Automatic data migration between PostgreSQL and SQLite
  • Advanced SQL queries
  • Real-time responses with SSE

🚀 Usage Examples

  • Run MCP server using main.py for database management with SSE.
  • Perform data migration using pg_to_sqlite.py.
  • Examples of CRUD operations are provided.