How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

AI for Database Connections API

Manage database connections, schemas, annotations, and execute SQL queries

AI for Database Connections API is one of 12 APIs that AI for Database publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

Tagged areas include Connections. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, an API reference, authentication docs, and rate-limit docs.

This API exposes 15 operations across 8 paths, and defines 19 schemas. It is described by OpenAPI 3.2.0, at version 1.0.0.

Requests are made against a single base URL, https://app.aifordatabase.com/api/v1.

15 operations 8 paths 19 schemas 2 DELETE5 GET2 PATCH6 POST

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
1.0.0
Base URL
https://app.aifordatabase.com/api/v1
Authentication
HTTP Bearer
Resource Areas
1

Authentication & Security 1

AI for Database Connections API declares 1 security scheme for authenticating requests. It accepts HTTP bearer tokens (API Key) (bearerAuth). By default, every request must be authenticated.

  • bearerAuth — Platform API key starting with afd

Paths & Operations 15

Across 8 paths, the API surfaces 15 operations — 2 DELETE, 5 GET, 2 PATCH, 6 POST. Each is listed below with its method, path, parameters, and response codes.

Connections 15

Manage database connections, schemas, annotations, and execute SQL queries

GET
/connections
List connections
listConnections 2 params → 200401
POST
/connections
Create connection
createConnection body → 201400403
GET
/connections/{id}
Get connection
getConnection 1 param → 200404
PATCH
/connections/{id}
Update connection
updateConnection 1 param body → 200400403404
DELETE
/connections/{id}
Delete connection
deleteConnection 1 param → 200403404
POST
/connections/{id}/test
Test connection
testConnection 1 param → 200404422
GET
/connections/{id}/schema
Get schema
getConnectionSchema 1 param → 200404
POST
/connections/{id}/schema
Introspect schema
introspectConnectionSchema 1 param → 200404422
POST
/connections/{id}/query
Execute SQL
executeQuery 1 param body → 200400404422
GET
/connections/{id}/annotations
List annotations
listAnnotations 4 params → 200404
POST
/connections/{id}/annotations
Create or upsert annotation
createAnnotation 1 param body → 201400404
GET
/connections/{id}/annotations/{annotationId}
Get annotation
getAnnotation 2 params → 200404
PATCH
/connections/{id}/annotations/{annotationId}
Update annotation
updateAnnotation 2 params body → 200400404
DELETE
/connections/{id}/annotations/{annotationId}
Delete annotation
deleteAnnotation 2 params → 200404
POST
/connections/{id}/annotations/auto
Auto-generate annotations
autoGenerateAnnotations 1 param body → 202404412

Schemas 19

The contract defines 19 schemas that model the data the API accepts and returns. The most detailed are Connection (14 properties), ConnectionUpdate (10 properties), Annotation (9 properties), ConnectionCreate (9 properties). Each schema is shown below with its type and property counts.

ConnectionCreate
object
9 properties 2 required
SchemaResult
object
3 properties
ApiMeta
object
3 properties 2 required
AutoAnnotationResult
object
4 properties
AnnotationCreate
object
5 properties 2 required
TestResult
object
6 properties
Annotation
object
9 properties
AnnotationUpdate
object
3 properties
QueryResult
object
Raw database result returned directly to the authenticated caller.
4 properties
Pagination
object
4 properties 4 required
Connection
object
Sanitized connection metadata. Passwords, encrypted credentials, and platform secrets are never returned.
14 properties
ConnectionUpdate
object
10 properties
SuccessEnvelope
object
3 properties 3 required
ApiError
object
3 properties 2 required
QueryRequest
object
1 property 1 required
DeletedResponse
object
1 property
AutoAnnotationRequest
object
1 property
Diagnosis
object
Structured failure diagnosis included in CONNECTIONFAILED / INTROSPECTIONFAILED error details.
6 properties
ErrorEnvelope
object
3 properties 3 required

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

aifordatabase-connections-api-openapi.yml Raw ↑

Other APIs AI for Database publishes across the network.

AI for Database Chat API
AI for Database Conversations API
AI for Database Dashboards API
AI for Database Keys API
AI for Database Metrics API
AI for Database Query Approval API
AI for Database Saved Queries API
AI for Database Usage API
AI for Database Webhooks API
AI for Database Workflow Credentials API
AI for Database Workflows API
Where this information came from

This is an independent, third-party profile of AI for Database Connections API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.