RisingWave Sql API
The Sql API from RisingWave — 1 operation(s) for sql.
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/risingwave-sql-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.
A second provider on the same verified email joins the account you already have.
OpenAPI Specification
openapi: 3.2.0
info:
title: RisingWave Events Sql API
version: '1.0'
description: HTTP API for real-time event ingestion and SQL query execution against a running RisingWave instance. Supports inserting events into streaming tables and running PostgreSQL-compatible SQL queries.
contact:
name: RisingWave Labs
url: https://risingwave.com
license:
name: Apache 2.0
url: https://www.apache.org/licenses/LICENSE-2.0
servers:
- url: /v1
description: Base API path
tags:
- name: Sql
paths:
/sql:
post:
summary: Execute a SQL query
operationId: executeSQL
description: Execute a PostgreSQL-compatible SQL statement against the connected RisingWave instance and return the result set.
requestBody:
required: true
content:
text/plain:
schema:
type: string
description: SQL query to be executed
example: SELECT * FROM page_views LIMIT 10;
responses:
'200':
description: SQL query executed successfully
content:
application/json:
schema:
$ref: '#/components/schemas/QueryResponse'
example:
columns:
- name: user_id
type: VARCHAR
isPrimaryKey: false
isHidden: false
- name: event_type
type: VARCHAR
isPrimaryKey: false
isHidden: false
- name: url
type: VARCHAR
isPrimaryKey: false
isHidden: false
- name: ts
type: BIGINT
isPrimaryKey: false
isHidden: false
rows:
- user_id: u-42
event_type: page_view
url: /docs/intro
ts: 1717200000000
rowsAffected: 1
'400':
description: Bad request — invalid SQL syntax
'500':
description: Internal server error
tags:
- Sql
components:
schemas:
QueryResponse:
type: object
required:
- columns
- rows
- rowsAffected
properties:
columns:
type: array
items:
$ref: '#/components/schemas/Column'
description: Ordered list of columns in the result set
rows:
type: array
items:
type: object
description: A single result row. Keys are column names; values are the corresponding typed column values.
description: Result rows
rowsAffected:
type: integer
format: int32
description: Number of rows affected or returned by the query
error:
type: string
description: Error message if the query failed; absent on success
Column:
type: object
required:
- name
- type
- isPrimaryKey
- isHidden
properties:
name:
type: string
description: Name of the column
type:
type: string
description: Data type of the column (e.g. VARCHAR, BIGINT, BOOLEAN)
isPrimaryKey:
type: boolean
description: Whether the column is a primary key
isHidden:
type: boolean
description: Whether the column is hidden from standard queries
externalDocs:
description: RisingWave Documentation
url: https://docs.risingwave.com