PostgreSQL

Connect AI agents to PostgreSQL databases for query execution, data analysis, and database management automation

Prerequisites Before you begin, create an account and get your API Key.

Getting started

Connect to PostgreSQL databases to execute queries, analyze data, manage tables, and automate database operations through AI agents.

API

1. Install the SDKs (optional)

   pip

   pip install klavis
   
2. Create a Strata MCP Server with PostgreSQL

   Python

   from klavis import Klavis
   from klavis.types import McpServerName
   
   klavis_client = Klavis(api_key="YOUR_API_KEY")
   
   # Create a Strata MCP server with PostgreSQL
   response = klavis_client.mcp_server.create_strata_server(
       servers=[McpServerName.POSTGRES],
       user_id="user123"
   )
   

   userId specifies whose connected accounts and data you are accessing in Klavis. It should be a unique id for yourself, your team, or your organization.

   API Reference

   Full Strata API endpoints

3. Authenticate with API Key

   Python

   klavis_client.mcp_server.set_strata_auth(
       strata_id=response.strata_id,
       server_name=McpServerName.POSTGRES,
       auth_data={
           "api_key": "postgresql://username:password@host:port/database"
       }
   )
   

   Use the standard PostgreSQL connection string format: postgresql://username:password@host:port/database

   🎉 Your PostgreSQL MCP Server is ready! Once authentication is complete, you can use your MCP server URL with any MCP-compatible client.

UI

1. Open Dashboard

   Go to your Dashboard.

2. Choose PostgreSQL

   Select PostgreSQL from the list of available integrations.

3. Configure Connection

   Enter your PostgreSQL connection string in the configuration form.

4. Use in your app

   Copy the MCP endpoint URL and add it to your MCP-supported client (Claude Desktop, Cursor, VS Code, etc.).

Open Source

1. Clone repository (for developers to build from source)

   git clone https://github.com/klavis-ai/klavis
   cd klavis/mcp_servers/postgres
   
2. Run with Docker

   # Pull the Docker image
   docker pull ghcr.io/klavis-ai/postgres-mcp-server:latest
   
   # Run with connection string
   docker run -p 5000:5000 \
     -e POSTGRES_CONNECTION_STRING="postgresql://username:password@host:port/database" \
     ghcr.io/klavis-ai/postgres-mcp-server:latest
   
3. Configure MCP client

   {
     "mcpServers": {
       "postgres": {
         "url": "http://localhost:5000/mcp/"
       }
     }
   }
   

Available Tools

With our progressive discovery approach, Klavis System is capable of enabling all tools for PostgreSQL. Please use the get_tools API for more details. If you find any tool that is missing, please reach out to [e-mail].

Next Steps

AI Platform Integrations

Integrate Klavis MCP Servers with leading AI platforms

Integrations

Explore available MCP servers

API Reference

REST endpoints and schemas

White-label Authentication

Customize OAuth flows with your own branding