peaka-mcp-server

Model Context Protocol (MCP) is a new, standardized protocol for managing context between large language models (LLMs) and external systems.

Peaka Model Context Protocol server that provides access to Peaka SQL text2SQL capabilities.

This server enables LLMs to inspect schemas and execute sql queries on provided Peaka projects.

Components

Resources

• peaka_sql_query_rule_set
  • Peaka SQL Query Rule Set is guidelines for writing sql queries for Peaka.

Tools

• peaka_schema_retriever
  • Retrieve table metadata and schema. Metadata has column types and relationships of the table with other tables.
• peaka_query_golden_sqls
  • Query question/sql pairs from Peaka's golden sql vector store.
• peaka_execute_sql_query
  • Runs the given sql query on Peaka.

Usage with Claude Desktop

• Edit the configuration file config.json:
  • on macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
  • on Windows: %APPDATA%\Claude\claude_desktop_config.json
• Add the following configuration to the mcpServers object:

{
  "mcpServers": {
    "peaka": {
      "command": "npx",
      "args": ["-y", "@peaka/mcp-server-peaka@latest"],
      "env": {
        "PEAKA_API_KEY": "<YOUR_API_KEY>"
      }
    }
  }
}

Change the {PEAKA_API_KEY} with your project API Key. Check out Peaka Documentation for creating your API Key and follow detailed instructions by clicking here.

• Restart Claude Desktop

Environment variables

You can use following environment variable for configuration:

| Name | Description | Default Value | | -------------------- | -------------------------------------------------------------------- | ----------------------------------- | | DBC_BASE_URL | Base URL for the Peaka Data operations, used for running sql queries | https://dbc.peaka.host:4567 | | PEAKA_API_KEY | Project API key for authenticating with Peaka services. | - | | PARTNER_API_BASE_URL | Base URL for Peaka partner API | https://partner.peaka.studio/api/v1 |

Contact

For feature requests and bugs, please create an issue in this repo. For further support, see the following resources:

• Peaka Community Discord