sql.v1.Connection
`Connection` models a reusable endpoint and auth token to authenticate the caller to use that endpoint. Only `OrganizationAdmins` and `EnvironmentAdmins` will have the permissions to create, update and delete `Connections`. `FlinkDevelopers` and `ModelResourceOwners` can later reference a `Connection` resource within their Model creation statements. The API allows you to list, create, read, and delete your connections. ## The Connections Model
Properties
| Name | Type | Description |
|---|---|---|
| api_version | string | APIVersion defines the schema version of this representation of a resource. |
| kind | string | Kind defines the object this REST resource represents. |
| metadata | object | |
| name | string | The user provided name of the resource, unique within this environment. |
| spec | object | |
| status | object |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "https://raw.githubusercontent.com/api-evangelist/confluent/main/json-schema/confluent-sql-v1-connection-schema.json",
"title": "sql.v1.Connection",
"description": "`Connection` models a reusable endpoint and auth token to authenticate the caller to\nuse that endpoint.\nOnly `OrganizationAdmins` and `EnvironmentAdmins` will have the permissions to create, update and delete `Connections`.\n`FlinkDevelopers` and `ModelResourceOwners` can later reference a `Connection` resource within their Model\ncreation statements.\nThe API allows you to list, create, read, and delete your connections.\n## The Connections Model\n<SchemaDefinition schemaRef=\"#/components/schemas/sql.v1.Connection\" />",
"x-generated": "2026-10-04",
"x-method": "derived",
"x-generator": "derive-json-schema.py",
"x-source": "openapi/confluent-connections-sql-v1-api-openapi.yml#/components/schemas/sql.v1.Connection",
"type": "object",
"properties": {
"api_version": {
"type": "string",
"enum": [
"sql/v1"
],
"description": "APIVersion defines the schema version of this representation of a resource.",
"readOnly": true
},
"kind": {
"type": "string",
"description": "Kind defines the object this REST resource represents.",
"enum": [
"Connection"
],
"readOnly": true
},
"metadata": {
"allOf": [
{
"$ref": "#/$defs/ObjectMeta"
},
{
"properties": {
"self": {},
"uid": {},
"resource_version": {},
"resource_name": {}
}
}
]
},
"name": {
"type": "string",
"description": "The user provided name of the resource, unique within this environment.",
"pattern": "[a-z0-9]([-a-z0-9]*[a-z0-9])?(\\.[a-z0-9]([-a-z0-9]*[a-z0-9])?)*",
"x-immutable": true,
"maxLength": 100
},
"spec": {
"$ref": "#/$defs/sql.v1.ConnectionSpec"
},
"status": {
"$ref": "#/$defs/sql.v1.ConnectionStatus"
}
},
"$defs": {
"ObjectMeta": {
"description": "ObjectMeta is metadata that all persisted resources must have, which includes all objects users must create.",
"required": [
"self"
],
"properties": {
"self": {
"description": "Self is a Uniform Resource Locator (URL) at which an object can be addressed. This URL encodes the service location, API version, and other particulars necessary to locate the resource at a point in time",
"type": "string",
"format": "uri",
"readOnly": true
},
"resource_name": {
"description": "Resource Name is a Uniform Resource Identifier (URI) that is globally unique across space and time. It is represented as a Confluent Resource Name",
"type": "string",
"format": "uri",
"readOnly": true
},
"created_at": {
"type": "string",
"format": "date-time",
"readOnly": true,
"description": "The date and time at which this object was created. It is represented in RFC3339 format and is in UTC."
},
"updated_at": {
"type": "string",
"format": "date-time",
"readOnly": true,
"description": "The date and time at which this object was last updated. It is represented in RFC3339 format and is in UTC."
},
"deleted_at": {
"type": "string",
"format": "date-time",
"readOnly": true,
"description": "The date and time at which this object was (or will be) deleted. It is represented in RFC3339 format and is in UTC."
}
},
"readOnly": true
},
"sql.v1.ConnectionSpec": {
"type": "object",
"description": "Encapsulates the model provider access details",
"properties": {
"connection_type": {
"type": "string",
"description": "The type of this connection.",
"x-immutable": true,
"x-extensible-enum": [
"AZUREML",
"AZUREOPENAI",
"A2A",
"ANTHROPIC",
"BEDROCK",
"CONFLUENT_JDBC",
"COSMOSDB",
"COUCHBASE",
"ELASTIC",
"FIREWORKSAI",
"GOOGLEAI",
"MCP_SERVER",
"MONGODB",
"OPENAI",
"PINECONE",
"REST",
"S3VECTORS",
"SAGEMAKER",
"VERTEXAI"
]
},
"endpoint": {
"type": "string",
"description": "The endpoint that is used to run model inferencing.",
"maxLength": 16384,
"x-immutable": true
},
"auth_data": {
"type": "object",
"description": "The vendor specific authentication token details\n\nThe contents are stored as opaque bytes given in plaintext by an EnvAdmin.\nIn future, we would support more secure methods for distributing authentication tokens.\n",
"oneOf": [
{
"$ref": "#/$defs/sql.v1.PlaintextProvider"
}
],
"x-immutable": false
}
},
"x-enable-listmeta": true,
"x-enable-objectmeta": true
},
"sql.v1.ConnectionStatus": {
"type": "object",
"required": [
"phase"
],
"description": "The status of the Connection",
"properties": {
"phase": {
"type": "string",
"x-extensible-enum": [
"ACTIVE",
"UNREACHABLE",
"INVALID_AUTH"
],
"description": "Describes the status of the connection:\n\nREADY: The Connection is usable;\n\nUNREACHABLE: The Connection endpoint is unreachable;\n\nINVALID_AUTH: The Connection auth token is invalid;\n",
"readOnly": true
},
"detail": {
"type": "string",
"description": "Details about why connection transitioned into a given status.",
"readOnly": true
}
},
"readOnly": true
},
"sql.v1.PlaintextProvider": {
"type": "object",
"description": "Describes a sensitive piece of information passed in plaintext.\n\nConfluent only accepts authentication tokens of supported model providers from OrgAdmins and EnvAdmins.\nFor now, only 'PlainText' provider is supported. It stores authentication token details as opaque bytes in an encrypted form.\nThis option offers limited security as it only provides a single level of encryption.\n",
"properties": {
"kind": {
"description": "Plaintext Provider Kind Type\n",
"type": "string",
"enum": [
"PlaintextProvider"
],
"x-immutable": true
},
"data": {
"description": "Authentication token in plaintext JSON string.\nFor composite tokens, provide them as JSON.\nThis is sensitive piece of information stored as opaque bytes in an encrypted form with single level of encryption.\n\nScoped to an endpoint of a `Connection` resource.\n",
"type": "string",
"format": "byte"
}
}
}
}
}
Work with this as data
Every JSON Schema 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 schemas
4 MCP tools reach this
find_json_schemasBrowse and filter every JSON Schema in the catalog.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
curl "https://apis.io/api/v1/json-schemas/confluent-sql-v1-connection"
curl "https://apis.io/api/v1/json-schemas?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.