Get detailed query analysis with execution statistics for SQL statements in watsonx.data. Supports Presto and Prestissimo engines with optional verbose output.
Apache 2.0
649,985 tools. Updated 2026-10-10 07:32
"Presto" matching MCP tools:
- Resume a paused Presto engine to restore its ability to run queries in watsonx.data.Apache 2.0
- List filtered Presto tables in watsonx.data using container type, container ID, Presto instance CRN, and engine ID. Supports asset discovery for queries and data management.Apache 2.0
- Scale a Presto engine by specifying coordinator and worker node counts in watsonx.data. Optionally change node types during scaling.Apache 2.0
- Create a new schema in a watsonx.data object storage catalog using a Presto or Prestissimo engine. Specify catalog, schema name, engine, custom path, and storage.Apache 2.0
- Retrieve TTC fare rates by rider category and payment type, including the 2-hour transfer rule. Filter by adult, senior, youth, or child, and by Presto, cash, day pass, or monthly.MIT
Matching MCP Servers
- AlicenseNot gradedqualityCmaintenanceIntegrates Presto construction budgeting software with Claude Code, enabling analysis, audit, and search of BC3 budget files locally or via WebAPI.MIT
- AlicenseNot gradedqualityDmaintenanceThis read-only MCP Server allows you to connect to Presto data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).1MIT
Matching MCP Connectors
Query a live PrestaShop e-commerce store: search the catalog, get product details, real-time prices and stock. Fondouk is an open-source module (MIT) that makes any PrestaShop store speak MCP and UCP — this connector is its public demo store. Read-only, public data only.
Restaurant and bar opening leads, fused from public liquor, permit and business filings into one scored venue. Tools: coverage, new_openings, watch_area, venue_signals.
- View available compute engines in IBM watsonx.data, filtered by type (Presto, Prestissimo, Spark) or all. Returns engine details and summary counts.Apache 2.0
- Analyze SQL query execution plans without running the query. Choose from logical, distributed, validate, or io plan types to understand query behavior and optimize performance.Apache 2.0
- Create a Presto engine in watsonx.data to enable SQL querying across your data lakehouse. Configure node types, autoscaling, and catalog associations.Apache 2.0
- Update a Presto engine's configuration: change description, display name, properties, tags, or trigger a restart.Apache 2.0
- Pause a running Presto engine in your watsonx.data lakehouse to stop query processing and free up resources.Apache 2.0
- Restart a specified Presto engine in IBM watsonx.data to recover from failures or apply updates. Provide the engine ID to trigger the restart.Apache 2.0
- Analyze SQL to extract table and column lineage, including source columns and full trace paths. Supports multiple SQL dialects for detailed dependency mapping.MIT
- Add a tempo marking to your score by specifying beats per minute and optional tempo text like Allegro or Andante.MIT
- Validate SQL syntax by checking parseability, then return the statement type and target tables as JSON. Supports multiple SQL dialects including Presto.MIT
- Run natural language queries against selected Presto tables in watsonx.data. Specify container, engine, and tables to retrieve data assets without writing SQL.Apache 2.0
- Convert a SQL statement from one dialect to another — mysql, postgres, sqlite, tsql, oracle, snowflake, bigquery, redshift, spark, hive, presto, trino, duckdb, clickhouse, databricks, doris, starrocks and more. Deterministic parser (sqlglot), not an LLM: the same input always produces the same output, and syntax errors come back with the exact line and column. Use it when migrating queries between databases or debugging dialect-specific syntax.ConnectorNo auth
- Convert a SQL statement from one dialect to another — mysql, postgres, sqlite, tsql, oracle, snowflake, bigquery, redshift, spark, hive, presto, trino, duckdb, clickhouse, databricks, doris, starrocks and more. Deterministic parser (sqlglot), not an LLM: the same input always produces the same output, and syntax errors come back with the exact line and column. Use it when migrating queries between databases or debugging dialect-specific syntax.ConnectorNo auth
- Convert a SQL statement from one dialect to another — mysql, postgres, sqlite, tsql, oracle, snowflake, bigquery, redshift, spark, hive, presto, trino, duckdb, clickhouse, databricks, doris, starrocks and more. Deterministic parser (sqlglot), not an LLM: the same input always produces the same output, and syntax errors come back with the exact line and column. Use it when migrating queries between databases or debugging dialect-specific syntax.ConnectorNo auth
- Convert a SQL statement from one dialect to another — mysql, postgres, sqlite, tsql, oracle, snowflake, bigquery, redshift, spark, hive, presto, trino, duckdb, clickhouse, databricks, doris, starrocks and more. Deterministic parser (sqlglot), not an LLM: the same input always produces the same output, and syntax errors come back with the exact line and column. Use it when migrating queries between databases or debugging dialect-specific syntax.ConnectorNo auth
- Returns connection status and URLs. When all providers are connected, returns authenticated:true and empty pending[]. When credentials are missing, returns connect_url for the toolkit and per-install URLs.ConnectorNo auth