OpenMetadata

OpenMetadata Database Schemas API

A `Database Schema` is collection of tables, views, stored procedures, and other database objects.

Documentation GitHub OpenAPI

Business capability

Information & Data Management BC-610

Operations 26

GET /v1/databaseSchemas/{id}/databaseSchemaProfilerConfig Get databaseSchema profile config #

PUT /v1/databaseSchemas/{id}/databaseSchemaProfilerConfig Add databaseSchema profile config #

DELETE /v1/databaseSchemas/{id}/databaseSchemaProfilerConfig Delete database profiler config #

PUT /v1/databaseSchemas/{id}/followers Add a follower #

PUT /v1/databaseSchemas/bulk Bulk create or update databaseSchemas #

GET /v1/databaseSchemas List database schemas #

PUT /v1/databaseSchemas Create or update schema #

POST /v1/databaseSchemas Create a schema #

GET /v1/databaseSchemas/name/{fqn} Get a schema by fully qualified name #

DELETE /v1/databaseSchemas/name/{fqn} Delete a schema by fully qualified name #

PATCH /v1/databaseSchemas/name/{fqn} Update a database schema by name #

GET /v1/databaseSchemas/{id} Get a schema by Id #

DELETE /v1/databaseSchemas/{id} Delete a schema by Id #

PATCH /v1/databaseSchemas/{id} Update a database schema #

DELETE /v1/databaseSchemas/async/{id} Asynchronously delete a schema by Id #

DELETE /v1/databaseSchemas/{id}/followers/{userId} Remove a follower #

GET /v1/databaseSchemas/name/{name}/export Export database schema in CSV format #

GET /v1/databaseSchemas/name/{name}/exportAsync Export database schema in CSV format #

GET /v1/databaseSchemas/{id}/versions/{version} Get a version of the schema #

PUT /v1/databaseSchemas/name/{name}/import Import tables from CSV to update database schema (no creation allowed) #

PUT /v1/databaseSchemas/name/{name}/importAsync Import tables from CSV to update database schema asynchronously (no creation… #

GET /v1/databaseSchemas/history List all entity versions within a time range #

GET /v1/databaseSchemas/{id}/versions List schema versions #

PUT /v1/databaseSchemas/restore Restore a soft deleted database schema #

GET /v1/databaseSchemas/entityRelationship Search Schema Entity Relationship #

PUT /v1/databaseSchemas/{id}/vote Update Vote for a Entity #

Documentation

📖

Documentation

https://docs.open-metadata.org/latest/main-concepts/metadata-standard/apis

📖

Authentication

https://docs.open-metadata.org/latest/main-concepts/metadata-standard/apis

Specifications

⚙

OpenAPI

https://raw.githubusercontent.com/api-evangelist/openmetadata/refs/heads/main/openapi/openmetadata-database-schemas-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/openmetadata-database-schemas-api"

All apis

curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

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

openapi: 3.2.0
info:
  title: OpenMetadata Database Schemas 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: '1.13'
servers:
- url: /api
  description: Current Host
- url: http://localhost:8585/api
  description: Endpoint URL
security:
- BearerAuth: []
tags:


# --- truncated at 32 KB (43 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/openmetadata/refs/heads/main/openapi/openmetadata-database-schemas-api-openapi.yml