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.
Call it yourself
curl for this page
This API
curl "https://apis.io/api/v1/apis/apache-hive-databases-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.
A second provider on the same verified email joins the account you already have.
OpenAPI Specification
openapi: 3.2.0
info:
title: Apache Hive WebHCat REST Databases API
version: 1.0.0
description: WebHCat REST API for Apache Hive providing DDL operations, HiveQL job submission, and Hive Metastore metadata access over HTTP.
contact:
email: user@hive.apache.org
license:
name: Apache 2.0
url: https://www.apache.org/licenses/LICENSE-2.0
servers:
- url: http://localhost:50111/templeton/v1
description: WebHCat (Templeton) REST API
tags:
- name: Databases
description: Database metadata operations
paths:
/ddl/database:
get:
operationId: listDatabases
summary: Apache Hive List Databases
description: List all databases in the Hive metastore.
tags:
- Databases
responses:
'200':
description: Databases listed
content:
application/json:
schema:
type: object
properties:
databases:
type: array
items:
type: string
/ddl/database/{dbName}:
get:
operationId: getDatabase
summary: Apache Hive Get Database
description: Get metadata for a specific Hive database.
tags:
- Databases
parameters:
- name: dbName
in: path
required: true
schema:
type: string
description: Database name
responses:
'200':
description: Database retrieved
content:
application/json:
schema:
$ref: '#/components/schemas/Database'
'404':
description: Database not found
components:
schemas:
Database:
type: object
description: Hive database (schema) in the metastore
properties:
name:
type: string
description: Database name
example: mydb
comment:
type: string
description: Database description
example: My analytics database
location:
type: string
description: HDFS location URI
example: hdfs://namenode/user/hive/warehouse/mydb.db
ownerName:
type: string
description: Owner of the database
example: hive
ownerType:
type: string
description: Owner type (USER or ROLE)
example: USER