Myriade

ai.myriade/myriade

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.

tools: 10
transport: HTTP
last updated: May 7, 2026

Open website

Tools

10 tools

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 params

List 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...

Parameters* required

limitinteger

Maximum results to return (1-200)default: 50

offsetinteger

Number of results to skip for paginationdefault: 0

myriade_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 params

Get 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.

Parameters* required

database_idstring

myriade_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 params

List 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...

Parameters* required

database_idstring

limitinteger

Maximum tables to return (1-500)default: 100

offsetinteger

Number of tables to skip for paginationdefault: 0

myriade_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 params

Get 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...

Parameters* required

database_idstring

schema_namevalue

table_namestring

myriade_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 params

Execute 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...

Parameters* required

database_idstring

sqlstring

myriade_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 params

Get 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...

Parameters* required

database_idstring

database_namevalue

limitinteger

Number of rows to return (1-20)default: 10

schema_namestring

table_namestring

myriade_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 params

Search 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...

Parameters* required

asset_typevalue

database_idstring

limitinteger

Maximum results to return (1-50)default: 20

textstring

myriade_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 params

Get 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...

Parameters* required

asset_idstring

database_idstring

myriade_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 params

Update 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...

Parameters* required

ai_suggestionvalue

asset_idstring

database_idstring

descriptionvalue

statusvalue

tag_idsvalue

myriade_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 params

Ask 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...

Parameters* required

database_idstring

questionstring

Details

Website: www.myriade.ai
Categories: AI & LLM Tools, Data & Analytics
Transport: HTTP
Registry: MCP registry, active

Related AI & LLM Tools MCP servers

View all

Ninar AIninar-ctrl/ninar.aiAudit your brand's visibility across ChatGPT, Gemini, Claude, Perplexity + 6 more engines.0stars

Scout by Optimlyai.optimly/scoutQuery the AI Brand Directory. Audit brand visibility in ChatGPT, Claude, and Gemini.0stars

OrgGen AIorggen-ai/orggen-mcpHuman-agent interface for projects: you prioritize and decide, your AI agents execute. Over MCP.0stars

Mcpsitepulsar/mcp-serverSitePulsar AEO audits: fetch FIND/READ/USE agent-readiness scores for any website.0stars

Stompy – AI Memory for Claude & MCP Agentsbanton/stompy-mcp-serverPersistent AI memory with semantic search, conflict detection, and ticketing.0stars

Canonical Company Searchai.trycanonical/company-searchVerified, long-tail company search: describe what you want, get an LLM-verified company shortlist.0stars