What is Mcp Openmetadata

mcp-openmetadata is a server that provides OpenMetadata APIs, designed for seamless integration with FastMCP services.

Use cases

Use cases include managing metadata for databases, tracking ownership of data assets, and providing sample data for testing and development.

How to use

To use mcp-openmetadata, install it via PyPi using either ‘uv pip install mcp-openmetadata’ or ‘pip install mcp-openmetadata’. Then, run the server with the appropriate environment variables for OpenMetadata URI and JWT token.

Key features

Key features include integration with OpenMetadata APIs, an easy-to-use interface for managing metadata, and support for table metadata, sample data, and ownership information.

Where to use

mcp-openmetadata can be used in data management, data governance, and analytics environments where metadata management is crucial.

MCP OpenMetadata

MCP server providing OpenMetadata APIs - A FastMCP integration for OpenMetadata services.

Features

• OpenMetadata API integration with FastMCP
• Easy-to-use interface for metadata management
• Support for table metadata, sample data, and ownership information

Installation

from PyPi (Cursor)

Install it to Cursor with (uv):

uv pip install mcp-openmetadata

uv run python -m mcp-openmetadata.hosts.cursor \
  -e OPENMETADATA_URI=<YOUR OPENMETADATA URI> \
  -e OPENMETADATA_JWT_TOKEN=<YOUR OPENMETADATA JWT TOKEN>

Install it to Cursor with (pip):

pip install mcp-openmetadata

python -m mcp-openmetadata.hosts.cursor \
  -e OPENMETADATA_URI=<YOUR OPENMETADATA URI> \
  -e OPENMETADATA_JWT_TOKEN=<YOUR OPENMETADATA JWT TOKEN>

from configuration

{
  "mcpServers": {
    "OpenMetadata": {
      "command": "uv",
      "args": [
        "run",
        "--with",
        "fastmcp",
        "--with",
        "httpx",
        "--with",
        "mcp-openmetadata",
        "python",
        "-m",
        "mcp_openmetadata.server"
      ],
      "env": {
        "OPENMETADATA_URI": "http://localhost:8585",
        "OPENMETADATA_JWT_TOKEN": "awesome_jwt_token"
      }
    }
  }
}

Environment Variables

Authorization

mcp-openmetadata provides token auth and basic auth:

Token Auth

OPENMETADATA_URI=http://localhost:8585
OPENMETADATA_JWT_TOKEN=<YOUR OPENMETADATA JWT TOKEN>

Basic Auth

OPENMETADATA_URI=http://localhost:8585
OPENMETADATA_USERNAME=<YOUR OPENMETADATA USERNAME>
OPENMETADATA_PASSWORD=<YOUR OPENMETADATA PASSWORD>

Tool list

mcp-openmetadata does not provide all APIs available in OpenMetadata.
Please refer to Supported APIs for the list of available APIs.

Since using the original API directly contains too much unnecessary data that is difficult to fit into the model context, we are working on returning somewhat organized results.

Search Tools

• search_entities_with_query: Search entities using query text. Supports pagination and sorting. Useful for:
  • Listing all tables/topics (q=*)
  • Searching by field names (e.g., q=columnNames:address)
  • Searching by tags (e.g., q=tags.tagFQN:user.email)
  • Complex queries with AND/OR operators
  • Filtering by service type, constraints, owners, etc.

Table Tools

• get_list_of_tables: Get a paginated list of tables with basic information
• get_table_by_fqn: Get detailed table information by fully qualified name
• get_table_columns_by_fqn: Get table columns information by fully qualified name
• get_table_owners_by_fqn: Get table ownership information by fully qualified name
• get_sample_data: Get sample data from a specified table

Each tool returns optimized responses with relevant fields to ensure compatibility with model context limits while providing essential metadata information.

License

This project is open source software licensed as MIT.