Mcp Postgresql
Schema-aware read/write access to PostgreSQL through Devart dotConnect ADO.NET data provider.
- Transport
- Not stated
- Package
- —
- Registry id
- com.devart/mcp-postgresql
No install snippet on purpose. A working MCP config is a command, its arguments and an environment block — the last two are where API keys live, so this catalogue never stores them and cannot publish them. Follow the link above for the authors' own instructions.
Devart MCP Server for PostgreSQL
Devart MCP Server for PostgreSQL enables AI clients to interact with your data through a secure server running in your environment. It turns a regular AI chat into a practical way to work with real-world business data — and it is faster than conventional export or manual querying.
Key benefits
Devart MCP Server for PostgreSQL allows you to:
- Work with data intuitively through natural language.
- Retrieve the required data for analysis within minutes.
- Report on your data faster with AI-powered assistance.
- Minimize manual data handling and integration maintenance.
How it works
Devart MCP Server for PostgreSQL helps AI clients communicate directly with PostgreSQL databases using natural-language prompts. It translates AI requests into structured queries, executes them through Devart connectivity drivers, and returns clean, structured results for seamless AI-powered data access.
Quick start
To get started with Devart MCP Server for PostgreSQL:
1. Download and install Devart ODBC Driver for PostgreSQL.
2. Download and install Devart MCP Server for PostgreSQL.
3. In Devart MCP Server for PostgreSQL, configure your data connection and integration settings.
4. Run your first natural-language query.
Manual installation and configuration
Prerequisites
Before building and running Devart MCP Server for PostgreSQL, ensure the following components are installed:
- .NET 8 SDK
- ADO.NET connection — Devart.AI.McpServer.AdoNet.PostgreSql.csproj Devart dotConnect for PostgreSQL (installed automatically via NuGet during build)
- ODBC connection — Devart.AI.McpServer.Odbc.PostgreSql.csproj Devart ODBC Driver for PostgreSQL (requires manual download and installation)
Step 1: Clone the repository
Clone the project repository and navigate to the project directory:
1. Open Command Prompt.
2. Enter the following command:
git clone https://github.com/devart-ai-connectivity/devart-mcp-server-postgresql.git
cd devart-mcp-server-postgresql
Step 2: Build the MCP Server from source
You can build Devart MCP Server for PostgreSQL from source using either of the supported database connectivity technologies: ADO.NET or ODBC.
- To build the MCP server with ADO.NET, run the following command:
dotnet publish Devart.AI.McpServer.AdoNet/Devart.AI.McpServer.AdoNet.PostgreSql/Devart.AI.McpServer.AdoNet.PostgreSql.csproj -c ReleasePostgreSql /p:TargetFramework=net8.0
The Devart dotConnect for PostgreSQL NuGet package is downloaded and restored automatically.
- To build the MCP server with ODBC, select the command based on the bitness of your data source.
For 64-bit data source, run the following command:
dotnet publish Devart.AI.McpServer.Odbc/Devart.AI.McpServer.Odbc.PostgreSql/Devart.AI.McpServer.Odbc.PostgreSql.csproj -c ReleasePostgreSql -r "win-x64" /p:TargetFramework=net8.0
For 32-bit data source, run the following command:
From the project's README.