ai.myriade/myriade MCP server

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.

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.

List databases configured in Myriade (paginated, sorted by name). Returns paginated database connections with their IDs, names, engines, and descriptions. Use the database ID with other tools.

Get detailed information about a specific database connection. Returns information about the database including its name, engine type, description, write mode, and any AI memory notes.

List tables in a database (paginated, sorted by database/schema/name). Returns a flat, paginated list of tables. Each item has database_name, schema, and name fields.

Execute a read-only SQL query against a database. Write operations (INSERT, UPDATE, DELETE, DROP, etc.) are blocked. Returns up to 50 rows of results with column metadata.

Get the column-level schema for a specific table. Returns column names, data types, and descriptions for the table. Raises if the user has no access to the table under governance.

Get sample rows from a table to understand the data. Returns a random sample of up to ``limit`` rows (max 20).

Update a catalog asset's documentation (requires edit rights). - ``description`` replaces the existing description (auto-sets status to "draft" if status is null). - ``tag_ids`` replaces all tags (accepts names or UUIDs; auto-creates missing tags). - ``status`` is "draft" (needs review) or "published". Only use "published" with high confidence. Use ``myriade_request_catalog_change`` instead when you lack edit rights or are not confident enough to write directly.

Propose a catalog change for the data team to review (no edit rights needed). Creates a reviewable suggestion routed to the asset's reviewers. Does NOT change the published catalog until approved. Use this instead of ``myriade_update_asset`` when you lack edit rights or are not confident enough to write directly.

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. Use this for complex analytical questions that require multiple steps; for simple schema lookups or direct SQL, prefer the other tools. Note: the agent has access to catalog write operations (create/update assets, tags, terms) — it may modify catalog state to record findings. Use myriade_query directly for strictly read-only inspection. Requires AGENTLYS_PROVIDER and the corresponding API key (e.g. AGENTLYS_PROVIDER=anthropic + ANTHROPIC_API_KEY).