AUTOMOTO MCP Gateway

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

От сообществаРаботаетНужен API-ключГлобальныйБесплатноМожет изменять данные

Что умеет

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

Какие данные видит

Нужен ли аккаунт

Нужен API-ключ из настроек сервиса

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.

Список инструментов сервера (12)

Технические названия из tools/list. Нужны только разработчикам.

list_catalogs	List all catalogs in Dremio
list_schemas	List all schemas in a catalog
list_tables	List all tables in a schema
execute_sql	Execute a SQL query
get_table_documentation	Get 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_documentation	Get 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_tables	Search 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_data	Get 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_stats	Get 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_sql	Validate 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_sql	Get 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_limits	Get 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.