postgresql-mcp-server-by-cdata

What is postgresql-mcp-server-by-cdata?

CData's Model Context Protocol (MCP) Server for PostgreSQL is a read-only server that allows LLMs like Claude Desktop to query live PostgreSQL data. It wraps the CData JDBC Driver for PostgreSQL, exposing the database as relational SQL models via a simple MCP interface, so users can ask natural language questions without writing SQL.

How to use postgresql-mcp-server-by-cdata?

Clone the repository, build the JAR with mvn clean install, download and install the CData JDBC Driver for PostgreSQL, license it, create a .prp file with JDBC connection properties, and configure your MCP client (e.g., Claude Desktop) by adding the server entry to claude_desktop_config.json. Run the server with java -jar CDataMCP-jar-with-dependencies.jar /path/to/postgresql.prp.

Key features of postgresql-mcp-server-by-cdata

• Read-only access to PostgreSQL data
• Natural language querying via LLM clients
• Built on CData JDBC Driver for PostgreSQL
• Easy integration with Claude Desktop
• Provides get_tables, get_columns, and run_query tools

Use cases of postgresql-mcp-server-by-cdata

• Ask an LLM for business insights from PostgreSQL without writing SQL
• Correlate data across PostgreSQL tables using conversational queries
• Retrieve live reports or counts from PostgreSQL during AI sessions
• Explore PostgreSQL schema and data through an MCP-enabled assistant

FAQ from postgresql-mcp-server-by-cdata

Is this server read-only?

Yes. This project builds a read-only MCP server. For full CRUD capabilities, CData offers a separate beta MCP Server for PostgreSQL.

What dependencies are required?

Java, Maven, and the CData JDBC Driver for PostgreSQL (download and license required).

How do I connect to my PostgreSQL database?

Create a .prp file with the JDBC connection string (generated via the CData JDBC Driver utility) and specify the driver path, class, and optional table filter.

Can I use this server with Claude Desktop?

Yes. Add a server entry to Claude Desktop's claude_desktop_config.json with the path to Java and the JAR, then restart Claude Desktop.

What transport does the server use?

The server uses stdio transport, so it can only be used with clients running on the same machine.