Postgresql MCP Server By Cdata

@CDataSoftware

Basic information

About Postgresql MCP Server By Cdata

This read-only MCP Server allows you to connect to PostgreSQL data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at

#postgresql #mcp-server #cdata

Postgresql MCP Server By Cdata config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

Postgresql MCP Server By Cdata tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

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.

Comments

More Databases MCP servers

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.