Aiven

Aiven Service:_PostgreSQL API

The Service:_PostgreSQL API from Aiven — 9 operation(s) for service:_postgresql.

Documentation GitHub OpenAPI

Operations 10

POST /account/{account_id}/pg/query/optimize Get query optimization recommendations for a query #

GET /project/{project}/service/{service_name}/pg/available-extensions List PostgreSQL extensions that can be loaded with CREATE EXTENSION in this… #

GET /pg/database-metadata-query Get the query used to retrieve schema metadata #

POST /pg/query/metadata-validate Validate schema metadata structure and statistics #

POST /project/{project}/service/{service_name}/pg/query/stats Fetch PostgreSQL service query statistics #

POST /project/{project}/service/{service_name}/query/stats Fetch PostgreSQL service query statistics (DEPRECATED: Use… #

POST /pg/query/validate Validate SQL query syntax #

POST /project/{project}/service/{service_name}/connection_pool Create a new connection pool for service #

DELETE /project/{project}/service/{service_name}/connection_pool/{pool_name} Delete a connection pool #

PUT /project/{project}/service/{service_name}/connection_pool/{pool_name} Update a connection pool #

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/aiven-service-postgresql-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:
  contact:
    email: support@aiven.io
    name: Aiven support team
    url: https://aiven.io/support-services
  title: 'Aiven API Documentation Service: Postgre SQL API'
  version: v1
  x-logo:
    altText: Aiven logo
    backgroundColor: '#fafafa'
    href: https://api.aiven.io/doc
    url: https://aiven.io/assets/img/aiven-logo.png
  description: '# Introduction


    Direct link to openapi.json for use with external tools


    Aiven is a modern fully-managed open source data platform for streaming, storing, and analyzing data on any public cloud.'
servers:
- url: https://api.aiven.io/v1
tags:


# --- truncated at 32 KB (36 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/aiven/refs/heads/main/openapi/aiven-service-postgresql-api-openapi.yml

Aiven Service:_PostgreSQL API

Operations 10

Documentation

Specifications

Schemas & Data

Other Resources

Work with this as data

MCP server

Tools for apis

Call it yourself

Get an API key

OpenAPI Specification