# Confluent Cloud SQL API v1 API

> Confluent Cloud SQL API v1 API on Apizie: 29 endpoints (List of Connections, Create a Connection, Read a Connection, Update a Connection, …) returned as clean JSON through one API key. Send your own provider key in the x-upstream-key header. Call it over REST at https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/{endpoint} or from Claude, ChatGPT and Cursor through the Apizie MCP server. Free plan: 1,000 requests a month.

- Project key: `cloud:confluent-flink-gateway-v1`
- Category: Cloud
- Status: byok
- Source: https://docs.confluent.io/cloud/current/api.html
- Page: https://apizie.tech/api/cloud/confluent-flink-gateway-v1
- OpenAPI: https://apizie.tech/api/cloud/confluent-flink-gateway-v1/openapi.json



## Endpoints

### List of Connections
`GET https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/list-sqlv1-connections` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| spec.connection_type | string | no | Filter the results by exact match for spec.connection_type |
| page_size | integer | no | A pagination size for collection requests. |
| page_token | string | no | An opaque pagination token for collection requests. |

### Create a Connection
`POST https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/create-sqlv1-connection` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| body | object | no | JSON request body |

### Read a Connection
`GET https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/get-sqlv1-connection` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| connection_name | string | yes | The user provided name of the Connection. Unique within a region within an org and env. |

### Update a Connection
`POST https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/update-sqlv1-connection` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| connection_name | string | yes | The unique identifier for the connection. |
| body | object | no | JSON request body |

### Delete a Connection
`POST https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/delete-sqlv1-connection` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| connection_name | string | yes | The unique identifier for the connection. |

### Read Statement Result
`GET https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/get-sqlv1-statement-result` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| name | string | yes | The unique identifier for the statement. |
| page_token | string | no | It contains the field offset in the CollectSinkFunction protocol. On the first request, it should be unset. The offset is assumed to start… |

### List of Statements
`GET https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/list-sqlv1-statements` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| spec.compute_pool_id | string | no | Filter the results by exact match for spec.compute_pool_id. When creating statements, if compute_pool_id is not specified, the statement… |
| page_size | integer | no | A pagination size for collection requests. |
| page_token | string | no | An opaque pagination token for collection requests. |
| label_selector | string | no | A comma-separated label selector to filter the statements. |

### Create a Statement
`POST https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/create-sqlv1-statement` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| body | object | no | JSON request body |

### Read a Statement
`GET https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/get-sqlv1-statement` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| statement_name | string | yes | The unique identifier for the statement. |

### Update a Statement
`POST https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/update-sqlv1-statement` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| statement_name | string | yes | The unique identifier for the statement. |
| body | object | no | JSON request body |

### Patch a Statement
`POST https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/patch-sqlv1-statement` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| statement_name | string | yes | The unique identifier for the statement. |
| body | object | no | JSON request body |

### Delete a Statement
`POST https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/delete-sqlv1-statement` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| statement_name | string | yes | The unique identifier for the statement. |

### List of Statement Exceptions
`GET https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/get-sqlv1-statement-exceptions` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| statement_name | string | yes | The unique identifier for the statement. |

### List all materialized tables
`GET https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/list-sqlv1-materialized-tables` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| page_size | integer | no | A pagination size for collection requests. |
| page_token | string | no | An opaque pagination token for collection requests. |

### Create a materialized table
`POST https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/create-sqlv1-materialized-table` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization |
| environment_id | string | yes | The unique identifier for the environment. |
| kafka_cluster_id | string | yes | The unique identifier for the database. |
| body | object | yes | JSON request body |

### Read a materialized table
`GET https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/get-sqlv1-materialized-table` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization |
| environment_id | string | yes | The unique identifier for the environment. |
| kafka_cluster_id | string | yes | The unique identifier for the database. |
| table_name | string | yes | The unique identifier for the Materialized Table |

### Update/Evolve a materialized table
`POST https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/update-sqlv1-materialized-table` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization |
| environment_id | string | yes | The unique identifier for the environment. |
| kafka_cluster_id | string | yes | The unique identifier for the database. |
| table_name | string | yes | The unique identifier for the Materialized Table |
| body | object | yes | JSON request body |

### Delete a materialized table
`POST https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/delete-sqlv1-materialized-table` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization |
| environment_id | string | yes | The unique identifier for the environment. |
| kafka_cluster_id | string | yes | The unique identifier for the database. |
| table_name | string | yes | The unique identifier for the Materialized Table |

### List all the versions of a materialized table
`GET https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/list-sqlv1-materialized-table-versions` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| kafka_cluster_id | string | yes | The unique identifier for the database. |
| table_name | string | yes | The unique identifier for the Materialized Table. |
| page_size | integer | no | A pagination size for collection requests. |
| page_token | string | no | An opaque pagination token for collection requests. |

### Read a materialized table version
`GET https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/get-sqlv1-materialized-table-version` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| kafka_cluster_id | string | yes | The unique identifier for the database. |
| table_name | string | yes | The unique identifier for the Materialized Table. |
| version | integer | yes | The version number of the Materialized Table. |

### List all agents
`GET https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/list-sqlv1-agents` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| page_size | integer | no | A pagination size for collection requests. |
| page_token | string | no | An opaque pagination token for collection requests. |

### Create an Agent
`POST https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/create-sqlv1-agent` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization |
| environment_id | string | yes | The unique identifier for the environment. |
| kafka_cluster_id | string | yes | The unique identifier for the database. |
| body | object | no | JSON request body |

### Read an Agent
`GET https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/get-sqlv1-agent` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization |
| environment_id | string | yes | The unique identifier for the environment. |
| kafka_cluster_id | string | yes | The unique identifier for the database. |
| agent_name | string | yes | The unique identifier for the Agent |

### Alter an Agent
`POST https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/update-sqlv1-agent` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization |
| environment_id | string | yes | The unique identifier for the environment. |
| kafka_cluster_id | string | yes | The unique identifier for the database. |
| agent_name | string | yes | The unique identifier for the Agent |
| body | object | yes | JSON request body |

### Delete an Agent
`POST https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/delete-sqlv1-agent` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization |
| environment_id | string | yes | The unique identifier for the environment. |
| kafka_cluster_id | string | yes | The unique identifier for the database. |
| agent_name | string | yes | The unique identifier for the Agent |

### List of Tools
`GET https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/list-sqlv1-tools` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| database_name | string | yes | The name of the database. |
| page_size | integer | no | A pagination size for collection requests. |
| page_token | string | no | An opaque pagination token for collection requests. |

### Create a Tool
`POST https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/create-sqlv1-tool` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| database_name | string | yes | The name of the database. |
| body | object | no | JSON request body |

### Read a Tool
`GET https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/get-sqlv1-tool` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| database_name | string | yes | The name of the database. |
| tool_name | string | yes | The user provided name of the Tool. |

### Delete a Tool
`POST https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/delete-sqlv1-tool` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| organization_id | string | yes | The unique identifier for the organization. |
| environment_id | string | yes | The unique identifier for the environment. |
| database_name | string | yes | The name of the database. |
| tool_name | string | yes | The user provided name of the Tool. |

## Example
```
curl "https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/list-sqlv1-connections" \
  -H "x-api-key: $APIZIE_KEY" \
  -H "x-upstream-key: $PROVIDER_KEY"
```

## FAQ

### How do I call the Confluent Cloud SQL API v1 API?
Create a free Apizie key, then send GET https://apizie.tech/v1/cloud:confluent-flink-gateway-v1/list-sqlv1-connections with the header x-api-key. Every endpoint returns { project, data, timestamp }.

### Is the Confluent Cloud SQL API v1 API free on Apizie?
Yes. The Free plan includes 1,000 requests a month at 100 requests a minute, no credit card. Confluent Cloud SQL API v1 itself also needs your own key from confluent.cloud.

### Can AI agents use the Confluent Cloud SQL API v1 API?
Yes. Add the Apizie MCP server (https://apizie.tech/mcp) to Claude, ChatGPT, Cursor or VS Code, then ask in plain language. The agent calls run_scraper with project key cloud:confluent-flink-gateway-v1.

### What is the status of the Confluent Cloud SQL API v1 API?
Needs your own provider key (bring your own key)