Oracle Database

Oracle Database Data Dictionary API

Database tables, views, columns, indexes, and object metadata

GitHub OpenAPI

Operations 28

GET /database/objects/tables/ Oracle Database Get all tables #
GET /database/objects/tables/{owner},{table_name} Oracle Database Get a specific table #
GET /database/objects/columns/ Oracle Database Get all table columns #
GET /database/objects/columns/{owner},{table_name},{column_name} Oracle Database Get a specific column #
GET /database/objects/indexes/ Oracle Database Get all indexes #
GET /database/objects/indexes/{owner},{index_name} Oracle Database Get a specific index #
GET /database/objects/functions/ Oracle Database Get all functions #
GET /database/objects/functions/{object_id} Oracle Database Get a specific function #
GET /database/objects/foreign_keys/ Oracle Database Get all foreign keys #
GET /database/tablespaces/ Oracle Database Get all tablespaces #
GET /database/objects/ Get all database objects #
GET /database/objects/{owner},{object_name},{object_type} Get a specific object #
GET /database/objects/arguments/ Get all arguments for functions and procedures #
GET /database/objects/arguments/{object_id},{subprogram_id},{argument_name} Get an argument #
GET /database/objects/foreign_keys/{owner},{constraint_name} Get a specific foreign keys #
GET /database/objects/materialized_view_logs/ Get all materialized view logs #
GET /database/objects/materialized_view_logs/{log_owner},{log_table} Get information on a specific materialized view log #
GET /database/objects/packages/procedures/ Get all procedures defined in package #
GET /database/objects/packages/procedures/{object_id},{subprogram_id} Get a procedure that is defined in package #
GET /database/objects/partitions/ Get all partitions in the database #
GET /database/objects/partitions/{table_owner},{table_name},{partition_name} Get a partition #
GET /database/objects/synonyms/ Get all synonyms in the database #
GET /database/objects/synonyms/{owner},{synonym_name} Get a synonym #
GET /database/tablespaces/{tablespace_name} Get a specific tablespace #
GET /database/objects/types/ Get all object types #
GET /database/objects/types/{owner},{type_name} Get an object type #

Documentation

📖
Documentation
https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/latest/
📖
Documentation
https://docs.oracle.com/iaas/Content/Database/home.htm
📖
APIReference
https://docs.oracle.com/iaas/api/#/en/database/20160918/
📖
Documentation
https://docs.oracle.com/en/database/oracle/simple-oracle-document-access/

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/openapi/oracle-database-data-dictionary-api-openapi.yml

Schemas & Data

📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-schema/oracle-database-table.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-schema/oracle-database-pluggable-database.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-schema/oracle-database-autonomous-database.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-schema/oracle-database-document.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-schema/oracle-database-collection.json

Other Resources

🔗
Swagger
https://example.oracle.com/ords/metadata-catalog/
🔗
JSONLD
https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/json-ld/oracle-database-context.jsonld
🔗
SDKs
https://docs.oracle.com/iaas/Content/API/Concepts/sdks.htm
🔗
REST API
https://docs.oracle.com/en/database/oracle/simple-oracle-document-access/rest/
🔗
Java API
https://docs.oracle.com/en/database/oracle/simple-oracle-document-access/java/

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/oracle-database:oracle-database-data-dictionary-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

oracle-database-data-dictionary-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Oracle Database Data Dictionary API
  x-refined-note:
  - x-refined-note differs across the merged source definitions and was not carried
  version: '1.0'
  description: 'Operations tagged Data Dictionary across 2 of this provider''s published API definitions: oracle-database-ords-openapi.yml, oracle-database-data-dictionary-api-openapi.yml. Each path carries the servers of the definition it was published in.'
servers:
- url: https://{host}:{port}/ords
  description: ORDS Server
  variables:
    host:
      default: localhost
      description: ORDS server hostname
    port:
      default: '8443'
      description: ORDS server port
tags:


# --- truncated at 32 KB (75 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/oracle-database/refs/heads/main/openapi/oracle-database-data-dictionary-api-openapi.yml