ai.myriade/myriade

Official11 tools

Explore and query your data warehouse through Myriade's AI data analyst agent.

AI-powered data analyst agent for exploring and querying data warehouse contents.

Captured live from the server via tools/list.

myriade_list_databases

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.

Parameters (2)

limitinteger
Maximum results to return (1-200)
offsetinteger
Number of results to skip for pagination

myriade_get_database_info

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.

Parameters (1)

database_idstringrequired
UUID of the database (from myriade_list_databases)

myriade_list_tables

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.

Parameters (3)

database_idstringrequired
UUID of the database
limitinteger
Maximum tables to return (1-500)
offsetinteger
Number of tables to skip for pagination

myriade_get_table_schema

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.

Parameters (3)

database_idstringrequired
UUID of the database
table_namestringrequired
Name of the table to inspect
schema_nameany
Optional schema name to disambiguate same-named tables

myriade_query

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.

Parameters (2)

database_idstringrequired
UUID of the database
sqlstringrequired
Read-only SQL query (writes are blocked)

myriade_sample_data

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

Parameters (5)

database_idstringrequired
UUID of the database
table_namestringrequired
Name of the table to sample
schema_namestringrequired
Schema containing the table
limitinteger
Rows to sample (1-20)
database_nameany
Optional warehouse-side database name (e.g. for Snowflake)

myriade_search_catalog

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.

Parameters (4)

database_idstringrequired
UUID of the database
textstringrequired
Search query — keep short (1-2 words) for best results
asset_typeany
Filter: "TABLE", "COLUMN", or "TERM"
limitinteger
Maximum results to return (1-50)

myriade_read_asset

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.

Parameters (2)

database_idstringrequired
UUID of the database
asset_idstringrequired
UUID of the asset to read

myriade_update_asset

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.

Parameters (5)

database_idstringrequired
UUID of the database
asset_idstringrequired
UUID of the asset to update
descriptionany
Replaces existing description; auto-sets status='draft' if status is null
tag_idsany
Tag names or UUIDs (replaces all tags). Auto-creates missing tags.
statusany
"draft" (needs review) or "published" (production-ready)

myriade_request_catalog_change

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.

Parameters (5)

database_idstringrequired
UUID of the database
asset_idstringrequired
UUID of the asset to propose a change for
fieldstringrequired
Field to change: "description" or "tags"
proposed_valuestringrequired
Proposed description text, or JSON-encoded list of tag names
rationalestringrequired
Why this change is proposed — shown to reviewers and in the activity feed

myriade_ask

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

Parameters (2)

database_idstringrequired
UUID of the database
questionstringrequired
Natural-language question about the data

Install

claude_desktop_config.json

{
  "mcpServers": {
    "myriade": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-remote",
        "https://app.myriade.ai/mcp/"
      ]
    }
  }
}

Desktop config is stdio-only; this bridges via mcp-remote. Native remote: Settings > Connectors.