Collate

Collate Databases API

A `Database` also referred to as `Database Catalog` is a collection of schemas.

GitHub OpenAPI
Business capability
Information & Data Management BC-610

Operations 28

GET /v1/databases/{id}/databaseProfilerConfig Get database profile config #
PUT /v1/databases/{id}/databaseProfilerConfig Add database profile config #
DELETE /v1/databases/{id}/databaseProfilerConfig Delete database profiler config #
PUT /v1/databases/{id}/followers Add a follower #
PUT /v1/databases/bulk Bulk create or update databases #
GET /v1/databases List databases #
PUT /v1/databases Create or update database #
POST /v1/databases Create a database #
GET /v1/databases/name/{fqn} Get a database by fully qualified name #
DELETE /v1/databases/name/{fqn} Delete a database by fully qualified name #
PATCH /v1/databases/name/{fqn} Update a database by name #
GET /v1/databases/{id} Get a database by Id #
DELETE /v1/databases/{id} Delete a database by Id #
PATCH /v1/databases/{id} Update a database #
DELETE /v1/databases/async/{id} Asynchronously delete a database by Id #
DELETE /v1/databases/{id}/followers/{userId} Remove a follower #
DELETE /v1/databases/deleteStale Delete stale databases within a scope #
GET /v1/databases/name/{name}/export Export database in CSV format #
GET /v1/databases/name/{name}/exportAsync Export database in CSV format #
GET /v1/databases/{id}/context Get the AI context for an entity by id #
GET /v1/databases/name/{fqn}/context Get the AI context for an entity by fully qualified name #
GET /v1/databases/{id}/versions/{version} Get a version of the database #
PUT /v1/databases/name/{name}/import Import database schemas from CSV to update database schemas (no creation… #
PUT /v1/databases/name/{name}/importAsync Import database schemas from CSV asynchronously #
GET /v1/databases/history List all entity versions within a time range #
GET /v1/databases/{id}/versions List database versions #
PUT /v1/databases/restore Restore a soft deleted Database #
PUT /v1/databases/{id}/vote Update Vote for a Entity #

Documentation

📖
Documentation
https://docs.open-metadata.org/latest/api-reference
📖
APIReference
https://docs.open-metadata.org/latest/api-reference

Specifications

⚙
OpenAPI
https://artifacts.apis.io/collate/openapi/collate-databases-api-openapi.yml

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/collate:collate-databases-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

collate-databases-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: OpenMetadata Databases API
  description: Common types and API definition for OpenMetadata
  contact:
    name: OpenMetadata
    url: https://open-metadata.org
    email: openmetadata-dev@googlegroups.com
  license:
    name: Apache 2.0
    url: https://www.apache.org/licenses/LICENSE-2.0
  version: 2.0.5
servers:
- url: /api
  description: Current Host
- url: http://localhost:8585/api
  description: Endpoint URL
security:
- BearerAuth: []
tags:


# --- truncated at 32 KB (47 KB total) ---
# Full source: https://artifacts.apis.io/collate/openapi/collate-databases-api-openapi.yml