peaka-mcp-server

peaka-mcp-server

3.2

If you are the rightful owner of peaka-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

Peaka Model Context Protocol server provides access to Peaka's text2SQL capabilities, enabling LLMs to inspect schemas and execute SQL queries on Peaka projects.

The Peaka Model Context Protocol (MCP) server is designed to facilitate the interaction between large language models (LLMs) and Peaka's text2SQL capabilities. This server allows LLMs to inspect database schemas and execute SQL queries on Peaka projects, making it a powerful tool for developers working with data-driven applications. By leveraging the standardized MCP, the server ensures seamless communication and data management between LLMs and external systems. The server is equipped with tools to retrieve schema metadata, query golden SQL pairs, and execute SQL queries, providing a comprehensive solution for managing database interactions. Additionally, the server supports integration with various platforms, including Claude Desktop, through simple configuration steps.

Features

  • Schema Inspection: Allows LLMs to retrieve and inspect table metadata and schema details.
  • SQL Execution: Enables the execution of SQL queries on Peaka projects.
  • Golden SQL Querying: Provides access to Peaka's golden SQL vector store for query question/SQL pairs.

Tools

  1. peaka_schema_retriever

    Retrieve table metadata and schema. Metadata has column types and relationships of the table with other tables.

  2. peaka_query_golden_sqls

    Query question/sql pairs from Peaka's golden sql vector store.

  3. peaka_execute_sql_query

    Runs the given sql query on Peaka.