Treasure Data Databases API
Manage Treasure Data 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.
Call it yourself
curl for this page
This API
curl "https://apis.io/api/v1/apis/treasure-data-databases-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"Discovery needs no key. Ratings and market analysis are Pro.
OpenAPI Specification
openapi: 3.2.0
info:
title: Treasure Data Databases API
version: '1.0'
description: 'Operations tagged Databases across 2 of this provider''s published API definitions: treasure-data-databases-api-openapi.yml, treasure-data-td-api-v3-openapi.yml. Each path carries the servers of the definition it was published in.'
servers:
- url: https://api.treasuredata.com/v3
description: Treasure Data API v3
- url: https://api.treasuredata.co.jp/v3
- url: https://api.ap02.treasuredata.com/v3
- url: https://api.eu01.treasuredata.com/v3
tags:
- name: Databases
description: Manage Treasure Data databases
paths:
/database/list:
get:
operationId: listDatabases
summary: List databases
description: Returns a list of all databases in the account.
tags:
- Databases
responses:
'200':
description: List of databases
content:
application/json:
schema:
type: object
properties:
databases:
type: array
items:
$ref: '#/components/schemas/Database'
'401':
$ref: '#/components/responses/Unauthorized'
security:
- TDAuth: []
servers:
- url: https://api.treasuredata.com/v3
description: Treasure Data API v3
/database/show/{database_name}:
get:
summary: Get database
description: Retrieves a specified database.
operationId: getDatabaseByName
tags:
- Databases
parameters:
- $ref: '#/components/parameters/path_database_name'
- $ref: '#/components/parameters/require_permissions'
responses:
'200':
description: OK
content:
application/json:
schema:
$ref: '#/components/schemas/Database_2'
security:
- ApiKeyAuth: []
servers:
- url: https://api.treasuredata.com/v3
- url: https://api.treasuredata.co.jp/v3
- url: https://api.ap02.treasuredata.com/v3
- url: https://api.eu01.treasuredata.com/v3
/database/create/{database_name}:
post:
summary: Create database
description: Creates a database.
operationId: createDatabase
tags:
- Databases
parameters:
- $ref: '#/components/parameters/path_database_name'
responses:
'200':
description: OK
content:
application/json:
schema:
type: object
additionalProperties: false
required:
- database
properties:
database:
$ref: '#/components/schemas/Database/properties/name'
security:
- ApiKeyAuth: []
servers:
- url: https://api.treasuredata.com/v3
- url: https://api.treasuredata.co.jp/v3
- url: https://api.ap02.treasuredata.com/v3
- url: https://api.eu01.treasuredata.com/v3
/database/delete/{database_name}:
post:
summary: Delete database
description: Deletes a specified database.
operationId: deleteDatabase
tags:
- Databases
parameters:
- $ref: '#/components/parameters/path_database_name'
responses:
'200':
description: OK
content:
application/json:
schema:
type: object
additionalProperties: false
required:
- database
properties:
database:
$ref: '#/components/schemas/Database/properties/name'
security:
- ApiKeyAuth: []
servers:
- url: https://api.treasuredata.com/v3
- url: https://api.treasuredata.co.jp/v3
- url: https://api.ap02.treasuredata.com/v3
- url: https://api.eu01.treasuredata.com/v3
components:
schemas:
Database:
type: object
properties:
name:
type: string
description: Database name
count:
type: integer
description: Number of tables
created_at:
type: string
format: date-time
updated_at:
type: string
format: date-time
permission:
type: string
Database_2:
title: Database
description: Database
type: object
additionalProperties: false
required:
- count
- created_at
- delete_protected
- name
- organization
- permission
- updated_at
properties:
count:
description: ???
type: integer
example: 5
created_at:
$ref: '#/components/schemas/DateTimeAsString'
delete_protected:
description: wheter the database is delete protected
type: boolean
example: true
datatank:
type: boolean
id:
$ref: '#/components/schemas/DatabaseIdAsString'
name:
description: database name
type: string
example: Alpha
organization:
description: the organization
type:
- string
- 'null'
example: Treasure Data
permission:
description: permissions
type:
- string
- 'null'
database_permissions:
description: permissions
type: object
additionalProperties: true
properties:
edit:
description: edit permission for database
type: boolean
delete:
description: delete permission for database
type: boolean
query:
description: query permission for database
type: boolean
import:
description: import permission for database
type: boolean
download:
description: download permission for database
type: boolean
updated_at:
$ref: '#/components/schemas/DateTimeAsString'
DatabaseIdAsString:
type: string
example: '7'
DateTimeAsString:
description: Datetime in custom format (`2020-12-31 11:22:33 -0500` or `2020-12-31 11:22:33 UTC` for UTC)
type: string
pattern: \d{4}-\d{2}-\d{2}\s\d{2}:\d{2}:\d{2}\s(([+-]\d{2}\d{2})|UTC)
example: 2020-12-31 11:22:33 UTC
DatabaseWithoutIdAndDatatank:
title: Database
description: Database
type: object
additionalProperties: false
required:
- count
- created_at
- delete_protected
- name
- organization
- permission
- updated_at
properties:
count:
description: the number of records in the database
type: integer
example: 5
created_at:
$ref: '#/components/schemas/DateTimeAsString'
delete_protected:
description: whether the database is delete protected
type: boolean
example: true
name:
description: database name
type: string
example: Alpha
organization:
description: the organization
type:
- string
- 'null'
example: Treasure Data
permission:
description: permissions
type:
- string
- 'null'
database_permissions:
description: permissions
type: object
additionalProperties: true
properties:
edit:
description: edit permission for database
type: boolean
delete:
description: delete permission for database
type: boolean
query:
description: query permission for database
type: boolean
import:
description: import permission for database
type: boolean
download:
description: download permission for database
type: boolean
updated_at:
$ref: '#/components/schemas/DateTimeAsString'
responses:
Unauthorized:
description: Authentication required or API key invalid
content:
application/json:
schema:
type: object
properties:
error:
type: string
parameters:
require_permissions:
name: require_permissions
in: query
required: false
schema:
type: string
pattern: 'true'
path_database_name:
name: database_name
in: path
required: true
schema:
$ref: '#/components/schemas/Database/properties/name'
securitySchemes:
TDAuth:
type: apiKey
in: header
name: Authorization
description: 'Treasure Data API key authentication. Set header value to "TD1 <your-api-key>".
'
ApiKeyAuth:
type: http
scheme: TD1
x-refined-from:
- treasure-data-databases-api-openapi.yml
- treasure-data-td-api-v3-openapi.yml