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.

Parameters2

limit	integer	optional	Maximum results to return (1-200)
offset	integer	optional	Number of results to skip for pagination

Raw schema

{
  "type": "object",
  "properties": {
    "limit": {
      "default": 50,
      "description": "Maximum results to return (1-200)",
      "maximum": 200,
      "minimum": 1,
      "title": "Limit",
      "type": "integer"
    },
    "offset": {
      "default": 0,
      "description": "Number of results to skip for pagination",
      "minimum": 0,
      "title": "Offset",
      "type": "integer"
    }
  },
  "title": "list_databasesArguments"
}

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.

Parameters1

database_id

string

required

UUID of the database (from myriade_list_databases)

Raw schema

{
  "type": "object",
  "properties": {
    "database_id": {
      "description": "UUID of the database (from myriade_list_databases)",
      "format": "uuid",
      "title": "Database Id",
      "type": "string"
    }
  },
  "required": [
    "database_id"
  ],
  "title": "get_database_infoArguments"
}

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.

Parameters3

database_id	string	required	UUID of the database
limit	integer	optional	Maximum tables to return (1-500)
offset	integer	optional	Number of tables to skip for pagination

Raw schema

{
  "type": "object",
  "properties": {
    "database_id": {
      "description": "UUID of the database",
      "format": "uuid",
      "title": "Database Id",
      "type": "string"
    },
    "limit": {
      "default": 100,
      "description": "Maximum tables to return (1-500)",
      "maximum": 500,
      "minimum": 1,
      "title": "Limit",
      "type": "integer"
    },
    "offset": {
      "default": 0,
      "description": "Number of tables to skip for pagination",
      "minimum": 0,
      "title": "Offset",
      "type": "integer"
    }
  },
  "required": [
    "database_id"
  ],
  "title": "list_tablesArguments"
}

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.

Parameters3

database_id	string	required	UUID of the database
table_name	string	required	Name of the table to inspect
schema_name	any	optional	Optional schema name to disambiguate same-named tables

Raw schema

{
  "type": "object",
  "properties": {
    "database_id": {
      "description": "UUID of the database",
      "format": "uuid",
      "title": "Database Id",
      "type": "string"
    },
    "table_name": {
      "description": "Name of the table to inspect",
      "maxLength": 255,
      "minLength": 1,
      "title": "Table Name",
      "type": "string"
    },
    "schema_name": {
      "anyOf": [
        {
          "maxLength": 255,
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Optional schema name to disambiguate same-named tables",
      "title": "Schema Name"
    }
  },
  "required": [
    "database_id",
    "table_name"
  ],
  "title": "get_table_schemaArguments"
}

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.

Parameters2

database_id	string	required	UUID of the database
sql	string	required	Read-only SQL query (writes are blocked)

Raw schema

{
  "type": "object",
  "properties": {
    "database_id": {
      "description": "UUID of the database",
      "format": "uuid",
      "title": "Database Id",
      "type": "string"
    },
    "sql": {
      "description": "Read-only SQL query (writes are blocked)",
      "maxLength": 20000,
      "minLength": 1,
      "title": "Sql",
      "type": "string"
    }
  },
  "required": [
    "database_id",
    "sql"
  ],
  "title": "queryArguments"
}

myriade_sample_data

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

Parameters5

database_id	string	required	UUID of the database
table_name	string	required	Name of the table to sample
schema_name	string	required	Schema containing the table
limit	integer	optional	Rows to sample (1-20)
database_name	any	optional	Optional warehouse-side database name (e.g. for Snowflake)

Raw schema

{
  "type": "object",
  "properties": {
    "database_id": {
      "description": "UUID of the database",
      "format": "uuid",
      "title": "Database Id",
      "type": "string"
    },
    "table_name": {
      "description": "Name of the table to sample",
      "maxLength": 255,
      "minLength": 1,
      "title": "Table Name",
      "type": "string"
    },
    "schema_name": {
      "description": "Schema containing the table",
      "maxLength": 255,
      "minLength": 1,
      "title": "Schema Name",
      "type": "string"
    },
    "limit": {
      "default": 10,
      "description": "Rows to sample (1-20)",
      "maximum": 20,
      "minimum": 1,
      "title": "Limit",
      "type": "integer"
    },
    "database_name": {
      "anyOf": [
        {
          "maxLength": 255,
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Optional warehouse-side database name (e.g. for Snowflake)",
      "title": "Database Name"
    }
  },
  "required": [
    "database_id",
    "table_name",
    "schema_name"
  ],
  "title": "sample_dataArguments"
}

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.

Parameters4

database_id	string	required	UUID of the database
text	string	required	Search query — keep short (1-2 words) for best results
asset_type	any	optional	Filter: "TABLE", "COLUMN", or "TERM"
limit	integer	optional	Maximum results to return (1-50)

Raw schema

{
  "type": "object",
  "properties": {
    "database_id": {
      "description": "UUID of the database",
      "format": "uuid",
      "title": "Database Id",
      "type": "string"
    },
    "text": {
      "description": "Search query — keep short (1-2 words) for best results",
      "maxLength": 200,
      "minLength": 1,
      "title": "Text",
      "type": "string"
    },
    "asset_type": {
      "anyOf": [
        {
          "enum": [
            "TABLE",
            "COLUMN",
            "TERM"
          ],
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Filter: \"TABLE\", \"COLUMN\", or \"TERM\"",
      "title": "Asset Type"
    },
    "limit": {
      "default": 20,
      "description": "Maximum results to return (1-50)",
      "maximum": 50,
      "minimum": 1,
      "title": "Limit",
      "type": "integer"
    }
  },
  "required": [
    "database_id",
    "text"
  ],
  "title": "search_catalogArguments"
}

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.

Parameters2

database_id	string	required	UUID of the database
asset_id	string	required	UUID of the asset to read

Raw schema

{
  "type": "object",
  "properties": {
    "database_id": {
      "description": "UUID of the database",
      "format": "uuid",
      "title": "Database Id",
      "type": "string"
    },
    "asset_id": {
      "description": "UUID of the asset to read",
      "format": "uuid",
      "title": "Asset Id",
      "type": "string"
    }
  },
  "required": [
    "database_id",
    "asset_id"
  ],
  "title": "read_assetArguments"
}

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.

Parameters5

database_id	string	required	UUID of the database
asset_id	string	required	UUID of the asset to update
description	any	optional	Replaces existing description; auto-sets status='draft' if status is null
tag_ids	any	optional	Tag names or UUIDs (replaces all tags). Auto-creates missing tags.
status	any	optional	"draft" (needs review) or "published" (production-ready)

Raw schema

{
  "type": "object",
  "properties": {
    "database_id": {
      "description": "UUID of the database",
      "format": "uuid",
      "title": "Database Id",
      "type": "string"
    },
    "asset_id": {
      "description": "UUID of the asset to update",
      "format": "uuid",
      "title": "Asset Id",
      "type": "string"
    },
    "description": {
      "anyOf": [
        {
          "maxLength": 10000,
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Replaces existing description; auto-sets status='draft' if status is null",
      "title": "Description"
    },
    "tag_ids": {
      "anyOf": [
        {
          "items": {
            "type": "string"
          },
          "maxItems": 50,
          "type": "array"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Tag names or UUIDs (replaces all tags). Auto-creates missing tags.",
      "title": "Tag Ids"
    },
    "status": {
      "anyOf": [
        {
          "enum": [
            "draft",
            "published"
          ],
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "\"draft\" (needs review) or \"published\" (production-ready)",
      "title": "Status"
    }
  },
  "required": [
    "database_id",
    "asset_id"
  ],
  "title": "update_assetArguments"
}

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.

Parameters5

database_id	string	required	UUID of the database
asset_id	string	required	UUID of the asset to propose a change for
field	string	required	Field to change: "description" or "tags"
proposed_value	string	required	Proposed description text, or JSON-encoded list of tag names
rationale	string	required	Why this change is proposed — shown to reviewers and in the activity feed

Raw schema

{
  "type": "object",
  "properties": {
    "database_id": {
      "description": "UUID of the database",
      "format": "uuid",
      "title": "Database Id",
      "type": "string"
    },
    "asset_id": {
      "description": "UUID of the asset to propose a change for",
      "format": "uuid",
      "title": "Asset Id",
      "type": "string"
    },
    "field": {
      "description": "Field to change: \"description\" or \"tags\"",
      "enum": [
        "description",
        "tags"
      ],
      "title": "Field",
      "type": "string"
    },
    "proposed_value": {
      "description": "Proposed description text, or JSON-encoded list of tag names",
      "maxLength": 10000,
      "title": "Proposed Value",
      "type": "string"
    },
    "rationale": {
      "description": "Why this change is proposed — shown to reviewers and in the activity feed",
      "maxLength": 2000,
      "title": "Rationale",
      "type": "string"
    }
  },
  "required": [
    "database_id",
    "asset_id",
    "field",
    "proposed_value",
    "rationale"
  ],
  "title": "request_catalog_changeArguments"
}

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

Parameters2

database_id	string	required	UUID of the database
question	string	required	Natural-language question about the data

Raw schema

{
  "type": "object",
  "properties": {
    "database_id": {
      "description": "UUID of the database",
      "format": "uuid",
      "title": "Database Id",
      "type": "string"
    },
    "question": {
      "description": "Natural-language question about the data",
      "maxLength": 4000,
      "minLength": 1,
      "title": "Question",
      "type": "string"
    }
  },
  "required": [
    "database_id",
    "question"
  ],
  "title": "askArguments"
}

ai.myriade/myriade

MCP Server: ai.myriade/myriade

🛠️ Key Features

🚀 Use Cases

⚡ Developer Benefits

⚠️ Limitations

myriade_list_databases

myriade_get_database_info

myriade_list_tables

myriade_get_table_schema

myriade_query

myriade_sample_data

myriade_search_catalog

myriade_read_asset

myriade_update_asset

myriade_request_catalog_change

myriade_ask

Install

Remote endpoint

Related servers