MCP-Server-postgres

MCP-Server-postgres

0
databases

This project provides tools for managing and interacting with PostgreSQL databases. It includes API endpoints for common database operations and utility functions for data serialization.

Overview

  • Database Connection Class: Manages PostgreSQL database connections with parameters for host, database, user, and password.
  • Auxiliary Functions:
    • JSON serialization for special data types such as datetime and Decimal.
  • Main Database Functions:
    • Listing all tables in the database.
    • Fetching detailed information about a specific table.
    • Querying data from tables with optional row limits.
    • Executing custom SQL queries.
  • MCP Tools (API Exposure):
    • API entry points for listing tables, getting table info, querying tables, and executing SQL queries.