vast-db-mcp

vast-db-mcp

3.2

If you are the rightful owner of vast-db-mcp 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.

The VAST DB MCP Server is a Model Context Protocol server that interfaces AI models with a VAST Data database, enabling secure and structured query execution.

The VAST DB MCP Server is designed to facilitate interaction between AI agents and a VAST Data database using the Model Context Protocol (MCP). It provides a secure and structured way for AI models to query information such as database schema, data samples, and execute read-only queries. The server is built using Python and leverages the MCP SDK and VAST DB SDK for seamless integration. It employs an ASGI server for handling requests and includes features like authentication, rate limiting, and error handling to ensure secure and efficient operations. The server supports various resources and tools, allowing AI agents to retrieve database schemas, list tables, access table metadata, and execute SQL queries. The project is structured to include cloned SDKs, main server logic, resource and tool handlers, and testing modules. It also emphasizes secure handling of credentials and provides detailed instructions for integrating with AI agent frameworks.

Features

  • Authentication: Secure access using VAST DB access and secret keys.
  • Rate Limiting: Configurable limits based on client IP to prevent abuse.
  • Resource Handlers: Access to database schema, table lists, and metadata.
  • Tool Handlers: Execute SQL queries with controlled statement types.
  • Error Handling: Comprehensive error responses for various failure scenarios.

Tools

  1. vast_sql_query

    Executes SQL queries against VAST DB with specified output format.