blaze-sql-mcp-server

blaze-sql-mcp-server

0
databasesai_chatbot

The BlazeSQL MCP Server is an MCP server designed to facilitate interaction with the BlazeSQL Natural Language Query API. It allows clients to execute natural language queries using the `blazesql_query` tool, offering secure authentication and robust validation.

BlazeSQL MCP Server

This project is a Model Context Protocol (MCP) server using the BlazeSQL Natural Language Query API. It enables MCP-compatible clients to interact with BlazeSQL through natural language queries.

Features

  • Built with the McpServer class from the MCP SDK.
  • Exposes the BlazeSQL Natural Language Query API as an MCP tool blazesql_query.
  • Utilizes zod for validation of tool inputs.
  • Secure API key authentication via environment variables.
  • Standard MCP stdio for client communication.

Prerequisites

  • Node.js (LTS)
  • Yarn
  • BlazeSQL account with API Key
  • BlazeSQL Natural Language Query API Documentation.

Setup

  1. Clone the repository.
  2. Install dependencies.
  3. Configure environment variables with your BlazeSQL API key.

Running the Server

  1. Build the server.
  2. Run the server with Node.

Connecting an MCP Client

Use stdio with the MCP Inspector or other integrated clients like Cursor and Claude 3.

Using the blazesql_query Tool

  • Tool Name: blazesql_query

  • Arguments:

    • db_id: ID of the database connection.
    • natural_language_request: Query in plain English.

  • Output:

    • Natural language response.
    • Generated SQL query.
    • Data results.