Amazon Athena

Amazon Athena Databases API

Operations for listing databases in a data catalog

Documentation GitHub OpenAPI

Operations 2

POST /#GetDatabase Get Database #

POST /#ListDatabases List Databases #

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/amazon-athena:amazon-athena-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

openapi: 3.1.0
info:
  title: Amazon Athena Databases API
  version: '2017-05-18'
  description: Generated from AWS's published Smithy model for Amazon Athena. 2 operation(s).
  contact:
    name: Amazon Web Services
    url: https://aws.amazon.com/contact-us/
  license:
    name: Apache 2.0
    identifier: Apache-2.0
    url: https://github.com/aws/api-models-aws/blob/main/LICENSE
servers:
- url: https://athena.{region}.amazonaws.com
  variables:
    region:
      default: us-east-1
security:
- sigv4: []
paths:
  /#GetDatabase:
    post:
      operationId: GetDatabase
      summary: Get Database
      description: Returns a database object for the specified database and data catalog.
      responses:
        '200':
          description: Success
          content:
            application/x-amz-json-1.1:
              schema:
                $ref: '#/components/schemas/GetDatabaseOutput'
        '500':
          description: InternalServerException
          content:
            application/x-amz-json-1.1:
              schema:
                $ref: '#/components/schemas/InternalServerException'
        '400':
          description: InvalidRequestException; MetadataException
          content:
            application/x-amz-json-1.1:
              schema:
                $ref: '#/components/schemas/InvalidRequestException'
      parameters:
      - name: X-Amz-Target
        in: header
        required: true
        schema:
          type: string
          enum:
          - AmazonAthena.GetDatabase
      requestBody:
        required: true
        content:
          application/x-amz-json-1.1:
            schema:
              $ref: '#/components/schemas/GetDatabaseInput'
      tags:
      - Databases
  /#ListDatabases:
    post:
      operationId: ListDatabases
      summary: List Databases
      description: Lists the databases in the specified data catalog.
      responses:
        '200':
          description: Success
          content:
            application/x-amz-json-1.1:
              schema:
                $ref: '#/components/schemas/ListDatabasesOutput'
        '500':
          description: InternalServerException
          content:
            application/x-amz-json-1.1:
              schema:
                $ref: '#/components/schemas/InternalServerException'
        '400':
          description: InvalidRequestException; MetadataException
          content:
            application/x-amz-json-1.1:
              schema:
                $ref: '#/components/schemas/InvalidRequestException'
      parameters:
      - name: X-Amz-Target
        in: header
        required: true
        schema:
          type: string
          enum:
          - AmazonAthena.ListDatabases
      requestBody:
        required: true
        content:
          application/x-amz-json-1.1:
            schema:
              $ref: '#/components/schemas/ListDatabasesInput'
      tags:
      - Databases
components:
  securitySchemes:
    sigv4:
      type: apiKey
      in: header
      name: Authorization
      description: AWS Signature Version 4. The Authorization header carries an AWS4-HMAC-SHA256 signature over the canonical
        request, with X-Amz-Date (and X-Amz-Security-Token for temporary credentials). Not a bearer token.
      x-aws-sigv4:
        signingName: athena
  schemas:
    Database:
      type: object
      properties:
        Name:
          type: string
          description: The name of the database.
        Description:
          type: string
          description: An optional description of the database.
        Parameters:
          type: object
          additionalProperties:
            type: string
          description: A set of custom key/value pairs.
      required:
      - Name
    GetDatabaseInput:
      type: object
      properties:
        CatalogName:
          type: string
          description: The name of the data catalog that contains the database to return.
        DatabaseName:
          type: string
          description: The name of the database to return.
        WorkGroup:
          type: string
          description: The name of the workgroup for which the metadata is being fetched. Required if requesting an IAM Identity
            Center enabled Glue Data Catalog.
      required:
      - CatalogName
      - DatabaseName
    GetDatabaseOutput:
      type: object
      properties:
        Database:
          $ref: '#/components/schemas/Database'
    InternalServerException:
      type: object
      properties:
        Message:
          type: string
    InvalidRequestException:
      type: object
      properties:
        AthenaErrorCode:
          type: string
        Message:
          type: string
    ListDatabasesInput:
      type: object
      properties:
        CatalogName:
          type: string
          description: The name of the data catalog that contains the databases to return.
        NextToken:
          type: string
          description: A token generated by the Athena service that specifies where to continue pagination if a previous request
            was truncated. To obtain the next set of pages, pass in the NextToken from the response object of the previous
            page call.
        MaxResults:
          type: integer
          description: Specifies the maximum number of results to return.
        WorkGroup:
          type: string
          description: The name of the workgroup for which the metadata is being fetched. Required if requesting an IAM Identity
            Center enabled Glue Data Catalog.
      required:
      - CatalogName
    ListDatabasesOutput:
      type: object
      properties:
        DatabaseList:
          type: array
          items:
            $ref: '#/components/schemas/Database'
          description: A list of databases from a data catalog.
        NextToken:
          type: string
          description: A token generated by the Athena service that specifies where to continue pagination if a previous request
            was truncated. To obtain the next set of pages, pass in the NextToken from the response object of the previous
            page call.
x-provenance:
  method: harvested
  publisher: Amazon Web Services
  source: https://raw.githubusercontent.com/aws/api-models-aws/3cd98287b471c106254abd89279cc87308d38bfd/models/athena/service/2017-05-18/athena-2017-05-18.json
  note: converted by smithy-to-openapi.py from AWS's Smithy model (roadmap#1001)