Connects Claude directly to your data warehouse through Myriade's AI analyst layer, which reverse-engineers table relationships, validates metrics, and documents your schema automatically. You ask questions in natural language and get SQL queries run against Snowflake, BigQuery, Databricks, Postgres, or other supported warehouses. The server uses Myriade's catalog to ground answers in actual table structure and business logic, so you're querying validated data models instead of raw tables. Useful when you want Claude to answer analytical questions without writing SQL yourself or when your warehouse documentation is incomplete. Requires a Myriade account with warehouse already connected through their platform.
Public tool metadata for what this MCP can expose to an agent.
myriade_list_databasesList databases configured in Myriade (paginated, sorted by name). Args: limit: Maximum results to return (default 50, max 200) offset: Number of results to skip for pagination Returns paginated database connections with their IDs, names, engines, and descriptions. Use the data...2 paramsList databases configured in Myriade (paginated, sorted by name). Args: limit: Maximum results to return (default 50, max 200) offset: Number of results to skip for pagination Returns paginated database connections with their IDs, names, engines, and descriptions. Use the data...
limitintegeroffsetintegermyriade_get_database_infoGet detailed information about a specific database connection. Args: database_id: The UUID of the database (from myriade_list_databases) Returns information about the database including its name, engine type, description, write mode, and any AI memory notes.1 paramsGet detailed information about a specific database connection. Args: database_id: The UUID of the database (from myriade_list_databases) Returns information about the database including its name, engine type, description, write mode, and any AI memory notes.
database_idstringmyriade_list_tablesList tables in a database (paginated, sorted by database/schema/name). Args: database_id: The UUID of the database (from myriade_list_databases) limit: Maximum tables to return (default 100, max 500) offset: Number of tables to skip for pagination Returns a flat, paginated lis...3 paramsList tables in a database (paginated, sorted by database/schema/name). Args: database_id: The UUID of the database (from myriade_list_databases) limit: Maximum tables to return (default 100, max 500) offset: Number of tables to skip for pagination Returns a flat, paginated lis...
limitintegeroffsetintegerdatabase_idstringmyriade_get_table_schemaGet the column-level schema for a specific table. Args: database_id: The UUID of the database (from myriade_list_databases) table_name: Name of the table to inspect schema_name: Optional schema name to disambiguate tables with the same name in different schemas Returns column...3 paramsGet the column-level schema for a specific table. Args: database_id: The UUID of the database (from myriade_list_databases) table_name: Name of the table to inspect schema_name: Optional schema name to disambiguate tables with the same name in different schemas Returns column...
table_namestringdatabase_idstringschema_namevaluemyriade_queryExecute a read-only SQL query against a database. The query is executed in read-only mode — write operations (INSERT, UPDATE, DELETE, DROP, etc.) are blocked. Args: database_id: The UUID of the database (from myriade_list_databases) sql: The SQL query to execute Returns up to...2 paramsExecute a read-only SQL query against a database. The query is executed in read-only mode — write operations (INSERT, UPDATE, DELETE, DROP, etc.) are blocked. Args: database_id: The UUID of the database (from myriade_list_databases) sql: The SQL query to execute Returns up to...
sqlstringdatabase_idstringmyriade_sample_dataGet sample rows from a table to understand the data. Args: database_id: The UUID of the database (from myriade_list_databases) table_name: Name of the table to sample schema_name: Schema containing the table limit: Number of rows to return (max 20) database_name: Optional data...5 paramsGet sample rows from a table to understand the data. Args: database_id: The UUID of the database (from myriade_list_databases) table_name: Name of the table to sample schema_name: Schema containing the table limit: Number of rows to return (max 20) database_name: Optional data...
limitintegertable_namestringdatabase_idstringschema_namestringdatabase_namevaluemyriade_search_catalogSearch the data catalog for tables, columns, or terms by name/description. Uses fuzzy matching and full-text search. Keep queries short (1-2 words) for best results. Args: database_id: The UUID of the database (from myriade_list_databases) text: Search query — short and focuse...4 paramsSearch the data catalog for tables, columns, or terms by name/description. Uses fuzzy matching and full-text search. Keep queries short (1-2 words) for best results. Args: database_id: The UUID of the database (from myriade_list_databases) text: Search query — short and focuse...
textstringlimitintegerasset_typevaluedatabase_idstringmyriade_read_assetGet detailed information about a catalog asset (table, column, schema). Returns the asset's description, tags, status, columns (for tables), sample data, parent hierarchy, and activity feed. Args: database_id: The UUID of the database (from myriade_list_databases) asset_id: Th...2 paramsGet detailed information about a catalog asset (table, column, schema). Returns the asset's description, tags, status, columns (for tables), sample data, parent hierarchy, and activity feed. Args: database_id: The UUID of the database (from myriade_list_databases) asset_id: Th...
asset_idstringdatabase_idstringmyriade_update_assetUpdate a catalog asset's documentation. Args: database_id: The UUID of the database (from myriade_list_databases) asset_id: The UUID of the asset to update description: New description (replaces existing). Auto-sets status to "draft" if status is null. ai_suggestion: Propose a...6 paramsUpdate a catalog asset's documentation. Args: database_id: The UUID of the database (from myriade_list_databases) asset_id: The UUID of the asset to update description: New description (replaces existing). Auto-sets status to "draft" if status is null. ai_suggestion: Propose a...
statusvaluetag_idsvalueasset_idstringdatabase_idstringdescriptionvalueai_suggestionvaluemyriade_askAsk a natural language question about a database using Myriade's data analyst agent. The agent will explore the database schema, search the catalog, run SQL queries, and analyze the results to answer your question. This is the most powerful tool — use it for complex analytical...2 paramsAsk a natural language question about a database using Myriade's data analyst agent. The agent will explore the database schema, search the catalog, run SQL queries, and analyze the results to answer your question. This is the most powerful tool — use it for complex analytical...
questionstringdatabase_idstringio.github.ericm1018/skillfm-llm-cost-optimizer-openai-anthropic-usage
io.github.mikerawsonnz/llm-orchestration-agent
io.github.mikerawsonnz/authenticated-llm-agent
labforgedev/copilot-memory-mcp
csoai-org/agent-prompt-injection-firewall-mcp
io.github.mikerawsonnz/authenticated-multi-llm-agent