AgentMCP
by inmydata
Overview
Provides AI agents with structured and conversational data querying, plus calendar functionalities, via a Model Context Protocol (MCP) server.
Installation
docker run -p 8000:8000 inmydata-mcp-serverEnvironment Variables
- INMYDATA_API_KEY
- INMYDATA_TENANT
- INMYDATA_CALENDAR
- INMYDATA_USER
- INMYDATA_SESSION_ID
- MCP_DUCKDB_LOCATION
- MCP_DEBUG
- INMYDATA_USE_OAUTH
- INMYDATA_MCP_HOST
- INMYDATA_AUTH_SERVER
- INMYDATA_SERVER
- INMYDATA_INTROSPECTION_CLIENT_ID
- INMYDATA_INTROSPECTION_CLIENT_SECRET
- INMYDATA_TOKEN_CACHE_TTL
Security Notes
The `query_results_fast` tool allows direct execution of user-provided SQL against a local DuckDB database. While confined to a local file, this presents a significant SQL injection risk if the AI agent or end-user provides malicious SQL. The server supports both OAuth (with token introspection for PATs) and API key authentication, handling credentials via environment variables or HTTP headers. It requires client ID/secret for OAuth introspection, which are read from environment variables. Proper HTTPS is recommended for remote deployments.
Similar Servers
mcp-server
Provides a Model Context Protocol (MCP) server for AI agents to search and retrieve curated documentation for the Strands Agents framework, facilitating AI coding assistance.
zeromcp
A minimal, pure Python Model Context Protocol (MCP) server for exposing tools, resources, and prompts via HTTP/SSE and Stdio transports.
alation-ai-agent-sdk
The MCP server enables AI agents and models to retrieve and leverage metadata from the Alation Data Catalog during inference, supporting use cases like data curation, search, and intelligent query generation.
mcp-mysql-server
Provides an MCP-compliant interface for AI models to securely interact with a MySQL database for CRUD operations, schema inspection, and performance analysis.