Skip to main content
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
  • UI
  • Open Source
1

Install the SDKs (optional)

pip install klavis
2

Create a Strata MCP Server with PostgreSQL

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"
)

API Reference

Full Strata API endpoints
3

Authenticate with API Key

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.

​
Available Tools

Tool NameDescription
queryRun a read-only SQL query against a PostgreSQL database
For more details about tool input schema, use the get_tools API.

​
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
⌘I