Data Product
A Model Context Protocol (MCP) server for discovering data products and requesting access in Data Mesh Manager, and executing queries on the data platform to access business data.
What is Data Product?
Data Product is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to model context protocol (mcp) server for discovering data products and requesting access in data mesh manager, and executing queries on the data platform to access business data.
A Model Context Protocol (MCP) server for discovering data products and requesting access in Data Mesh Manager, and executing queries on the data platform to access business data.
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- A Model Context Protocol (MCP) server for discovering data p
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx dataproductConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Data Product
The Data Product MCP Server bridges AI assistants with Data Mesh Manager, letting you discover data products, request access to output ports, and execute SQL queries directly against Snowflake, Databricks, or BigQuery data platforms — all from a single natural-language conversation. It implements four focused tools that cover the full data-product lifecycle: searching the catalog, retrieving product details, requesting access with a stated purpose, and querying data up to 100 rows at a time. This makes it ideal for data engineers, analysts, and product teams who want to explore the data mesh catalog and sample data without leaving their AI assistant.
Prerequisites
- Python 3.10+ with uv/uvx installed
- A Data Mesh Manager account and DATAMESH_MANAGER_API_KEY
- Credentials for at least one supported data platform: Snowflake, Databricks, or BigQuery
- An MCP client such as Claude Desktop
- Network access to api.datamesh-manager.com (or your self-hosted instance)
Obtain your Data Mesh Manager API key
Log in to Data Mesh Manager, navigate to your account settings, and generate an API key. This is required for all tool calls.
Gather data platform credentials
Depending on which output ports you want to query, collect the appropriate credentials: Snowflake username/password/warehouse/role, Databricks client ID/secret/host/HTTP path, or a BigQuery service account JSON path.
Add the server to your MCP client configuration
Edit your claude_desktop_config.json (or equivalent) to register the dataproduct_mcp server with uvx and all required environment variables.
{
"mcpServers": {
"dataproduct": {
"command": "uvx",
"args": ["dataproduct_mcp"],
"env": {
"DATAMESH_MANAGER_API_KEY": "your-api-key",
"DATACONTRACT_SNOWFLAKE_USERNAME": "your-username",
"DATACONTRACT_SNOWFLAKE_PASSWORD": "your-password",
"DATACONTRACT_SNOWFLAKE_WAREHOUSE": "your-warehouse",
"DATACONTRACT_SNOWFLAKE_ROLE": "your-role"
}
}
}
}Restart your MCP client
Restart Claude Desktop (or your chosen MCP client) to load the new server configuration. The dataproduct server should appear in the connected servers list.
Search and explore the data catalog
Use the dataproduct_search tool to find data products by keyword. Then use dataproduct_get to retrieve full details including output ports and schema information.
Request access and run queries
Call dataproduct_request_access with a data_product_id, output_port_id, and business purpose. Once access is granted, use dataproduct_query to execute SQL and retrieve up to 100 rows.
Data Product Examples
Client configuration
Full claude_desktop_config.json entry for the Data Product MCP Server with Databricks credentials.
{
"mcpServers": {
"dataproduct": {
"command": "uvx",
"args": ["dataproduct_mcp"],
"env": {
"DATAMESH_MANAGER_API_KEY": "dmm_xxxxxxxxxxxx",
"DATAMESH_MANAGER_HOST": "https://api.datamesh-manager.com",
"DATABRICKS_CLIENT_ID": "your-client-id",
"DATABRICKS_CLIENT_SECRET": "your-client-secret",
"DATABRICKS_HOST": "https://your-workspace.azuredatabricks.net",
"DATABRICKS_HTTP_PATH": "/sql/1.0/warehouses/abc123"
}
}
}
}Prompts to try
Natural-language prompts to use once the Data Product MCP Server is connected.
- "Search for data products related to 'customer orders'"
- "Get full details for data product ID dp-sales-orders-v2"
- "Request access to output port analytics-port on data product dp-sales-orders-v2 for quarterly revenue analysis"
- "Run a SQL query on the sales orders output port: SELECT region, SUM(revenue) FROM orders GROUP BY region LIMIT 10"
- "What output ports are available for the product catalog data product?"Troubleshooting Data Product
Authentication error: DATAMESH_MANAGER_API_KEY invalid or missing
Verify the API key in your config exactly matches the one from Data Mesh Manager settings. Ensure there are no leading/trailing spaces and that QUERY_ACCESS_EVALUATION_ENABLED is not blocking the call.
dataproduct_query fails with a platform connection error
Check that all platform-specific env vars are set (e.g., all four Snowflake vars or all four Databricks vars). A missing DATACONTRACT_SNOWFLAKE_WAREHOUSE or DATABRICKS_HTTP_PATH is the most common cause.
uvx cannot find or install dataproduct_mcp
Ensure uv is up to date ('pip install -U uv') and that your Python version is 3.10+. Run 'uvx dataproduct_mcp --help' in a terminal to verify the package installs correctly before adding it to the MCP config.
Frequently Asked Questions about Data Product
What is Data Product?
Data Product is a Model Context Protocol (MCP) server that model context protocol (mcp) server for discovering data products and requesting access in data mesh manager, and executing queries on the data platform to access business data. It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Data Product?
Follow the installation instructions on the Data Product GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Data Product?
Data Product works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Data Product free to use?
Yes, Data Product is open source and available under the MIT license. You can use it freely in both personal and commercial projects.
Data Product Alternatives — Similar Databases Servers
Looking for alternatives to Data Product? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Data Product in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Data Product?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.