AUTOMOTO MCP Gateway

Production-ready MCP Gateway for automotive market data powered by Dremio.

CommunityOnlineAPI key requiredGlobalFreeCan modify data

What it can do

  • List Catalogs: List all catalogs in Dremio
  • List Schemas: List all schemas in a catalog
  • List Tables: List all tables in a schema

What data it sees

Do you need an account

An API key from the service settings is required

Production-ready MCP Gateway for automotive market data powered by Dremio. Connect Claude, Cursor, GitHub Copilot or any MCP-compatible client to execute SQL queries on Ukrainian automotive datasets — vehicle catalogs, pricing analytics, VIN decoding. Built with FastAPI, Dremio, PostgreSQL, Redis.

How to connect

How to connect AUTOMOTO MCP Gateway to Claude

The server address to paste into Claude settings:

https://automoto-mcp-gateway--automoto-mcp-gateway.run.tools

  1. Open Claude (claude.ai or the desktop app).
  2. Go to Settings → Connectors.
  3. Click Add custom connector.
  4. Paste the server address copied below into Remote MCP server URL and click Add.
  5. In a chat, click + → Connectors and switch the new connector on.

Custom connectors are available on Free, Pro, Max, Team and Enterprise plans (Free is limited to one). On Team and Enterprise an organization Owner adds the connector first under Organization settings → Connectors.

Authorization

After you click Add, a sign-in window for the service opens. Sign in with your own account and approve access. Claude never sees your password.

How to connect AUTOMOTO MCP Gateway to ChatGPT

The server address to paste into ChatGPT settings:

https://automoto-mcp-gateway--automoto-mcp-gateway.run.tools

  1. Open ChatGPT in a browser (chatgpt.com). A Plus, Pro, Business, Enterprise or Edu plan is required.
  2. Turn on developer mode once: Settings → Apps → Advanced settings → Developer mode.
  3. Open Settings → Connectors and click Create.
  4. Fill in the form: Name (anything), Description (one line about what the service does), MCP server URL (copy it below).
  5. Under Authentication choose OAuth if the service requires sign-in, otherwise None. Click Create.
  6. In a new chat open + → Apps/Connectors and enable the connector.

OpenAI has renamed this section before (Connectors → Apps/Plugins). If the label differs, search settings for "developer mode". On Business/Enterprise workspaces an admin must allow custom connectors first.

Authorization

On first use ChatGPT opens the service's sign-in window. Sign in and approve access.

How to connect AUTOMOTO MCP Gateway to Cursor

The server address to paste into Cursor settings:

https://automoto-mcp-gateway--automoto-mcp-gateway.run.tools

Fastest: click Open in Cursor below and confirm the prompt.

Manually:

  1. In Cursor open Settings → Cursor Settings → MCP and click Add new global MCP server.
  2. Paste the JSON copied below into ~/.cursor/mcp.json (per project: .cursor/mcp.json in the repo root).
  3. Save the file. The server appears in the MCP list; authorize it there if asked.

Authorization

If the service needs sign-in, an authorize button appears next to the server in the MCP list.

Server tool list (12)

Raw names from tools/list. Only developers need these.

list_catalogsList all catalogs in Dremio
list_schemasList all schemas in a catalog
list_tablesList all tables in a schema
execute_sqlExecute a SQL query
get_table_documentationGet comprehensive documentation for a table including wiki descriptions. IMPORTANT: Use this tool FIRST when you need to understand what a table contains, its purpose, business context, or column meanings. Returns detailed information about a table including: - Wiki documentation (user-written descriptions, business context, data lineage, column explanations - very valuable!) - Column definitions (name, type, nullable, description from wiki) - View SQL definition (for views) - Sample SQL queries for the table - Related tables in the same schema - Business metrics — formulas and SQL expressions for calculating KPIs (e.g., DAU, AOV, Revenue, Conversion Rate) - Glossary — business terms and their definitions relevant to this table - Relations — links to dictionary/lookup/dimension tables with JOIN conditions The wiki field contains rich documentation written by data engineers explaining what the table is for, how to use it, and what each column means. The business_metrics field contains ready-to-use SQL formulas for key metrics. The relations field shows how to JOIN this table with dictionaries and other tables.
get_catalog_documentationGet documentation for all available catalogs in Dremio. Use this tool to get an overview of all data sources and their structure. Returns information about all catalogs including: - Catalog names and descriptions - Number of schemas per catalog - Number of tables per catalog - Summary totals
search_tablesSearch for tables matching a query string. Use this tool to find tables when you don't know the exact name. After finding a table, use get_table_documentation to get its wiki and understand what it contains. Searches across table names, schema names, and catalog names. Also searches in local metadata: descriptions, tags, aliases, keywords, business metric names, and glossary terms. Results are ranked by match quality.
get_sample_dataGet sample data from a table (max 100 rows). Use this tool to preview table contents and understand data format. Useful for verifying table structure before writing complex queries.
get_column_statsGet statistics for a specific column. Returns min/max values, null count, distinct count, and sample values. Useful for data profiling and understanding value distributions.
validate_sqlValidate SQL query syntax without executing it. Use this tool to check if a query is valid before running it. Returns validation result with any syntax errors.
explain_sqlGet execution plan for a SQL query. Shows how Dremio will execute the query, including scan operations, joins, and data flow. Useful for query optimization.
get_system_limitsGet system limits and constraints for AI operations. IMPORTANT: Call this tool at the start of a session to understand: - Maximum rows returned per query - Query timeout settings - Allowed/forbidden SQL operations - Best practices for efficient queries Helps AI avoid errors and write optimized queries.