vast-db-mcp

vast-db-mcp

0
databases

The VAST DB MCP Server project is designed to enable AI models to securely query and interact with a VAST Data database. It uses Python and various SDKs to provide an MCP-compliant interface, offering features like authentication, rate limiting, and a variety of query and metadata resources.

VAST DB MCP Server

This project implements a Model Context Protocol (MCP) server acting as an interface between AI agents and a VAST Data database, facilitating secure and structured queries.

Project Goal

  • Provide a protocol for AI models to query information and execute read-only queries against a VAST DB.

Core Technology

  • Python: >=3.9
  • MCP SDK
  • VAST DB SDK
  • ASGI Server: uvicorn

Implemented MCP Features

  • Authentication: Requires specific HTTP headers.
  • Rate Limiting: Configurable by environment variable.
  • Resources: Database Schema, List Tables, Table Metadata, Table Sample Data.
  • Tool: SQL Query Executor.

AI Agent Interaction Notes

  • Secure management of VAST DB credentials required.
  • Request construction includes generating correct URI paths and SQL arguments for resources.
  • Client-side code must handle various response types and error messages.

Potential Next Steps

  • Enhance logging, testing, and error handling. More resources/tools implemented and query validation improved.

How to Run

  1. Clone the repository.
  2. Set up environment by copying .env.example to .env.
  3. Install dependencies with recommended virtual environment.