subsets-mcp-server
Verified Safeby subsetsio
Overview
Provides a Model Context Protocol server for AI assistants to query and manage statistical datasets, either remotely from Subsets.io or locally via DuckDB.
Installation
uvx --from git+https://github.com/subsetsio/subsets-mcp-server.git mcp-server --api-key YOUR_API_KEYEnvironment Variables
- SUBSETS_API_URL
- SUBSETS_API_KEY
- R2_ACCOUNT_ID
- R2_ACCESS_KEY_ID
- R2_SECRET_ACCESS_KEY
Security Notes
The server's `execute_sql_query` tool directly executes arbitrary SQL queries provided as a string. While designed for AI-generated queries, this pattern can be a SQL injection vulnerability if the query parameter is not sanitized and comes from an untrusted source, potentially exposing or manipulating loaded datasets. The server relies on fetching and running code directly from a GitHub repository via `uvx`, introducing a supply chain risk if the repository were to be compromised. API keys and R2 credentials are read from files or environment variables, which is good practice.
Similar Servers
OpenMetadata
This server acts as a plugin for Apache Airflow, exposing REST APIs to manage OpenMetadata workflow definitions, DAGs, and tasks.
DBchat
Transforms a database into an intelligent conversational partner, enabling natural language queries, instant answers, and data visualizations via MCP clients.
mcp-server-datahub
Enables AI agents to interact with DataHub for comprehensive data discovery, governance, lineage exploration, and SQL query generation across an organization's data ecosystem.
teradata-mcp-server
A comprehensive Model Context Protocol (MCP) server for Teradata, exposing a rich suite of database administration, data quality, security, SQL optimization, vector store, plotting, backup/restore, feature store, and LLM chat/RAG capabilities as MCP tools for client applications like AI agents.