postgresql-mcp-server-by-cdata

postgresql-mcp-server-by-cdata

0
databases

The PostgreSQL MCP Server by CData is a specialized server that enables large language models (LLMs) to query live PostgreSQL data more easily. It connects to PostgreSQL via the CData JDBC Driver and provides a simple, natural language query interface. It is particularly useful for integration with AI clients such as Claude Desktop.

Overview

CData's Model Context Protocol (MCP) Server for PostgreSQL is a read-only server designed to allow LLMs to query PostgreSQL live data using the CData JDBC Driver. It exposes PostgreSQL data through an MCP interface, enabling natural language queries without SQL. The server supports integration with AI clients, specifically targeting usage with Claude Desktop.

Purpose

  • Facilitates querying of PostgreSQL by LLMs.
  • Wraps CData JDBC Driver for SQL model exposure.

Setup Guide

  • Clone the repository and build the server.
  • Install and license the CData JDBC Driver.
  • Configure data source connection via a .prp file.

Usage Details

  • AI clients can use built-in tools for data interaction.
  • Includes tools for retrieving tables and columns and executing queries.

Tools & Descriptions

  • "_get_tables": List available tables.
  • "_get_columns": List columns for a table.
  • "_run_query": Execute a SQL SELECT query.