Peaka MCP Server

Example Use Cases

• 1

  Inspect table metadata and relationships in a Peaka project before generating queries.

• 2

  Example question-to-SQL pairs (golden SQLs) to guide or validate generated queries.

• 3

  Run SQL queries directly against Peaka projects and retrieve results programmatically.

Description

This server implements the Model Context Protocol (MCP) for Peaka, exposing tools and resources to let LLMs retrieve table metadata, fetch example question/SQL pairs, and execute SQL against Peaka projects. It provides schema retrievers, a golden-SQL search tool, and a SQL execution tool, enabling safer and more accurate SQL generation and execution from models. Useful for integrating Peaka's text2SQL capabilities into agent workflows and LLM-based tools.