Materialize Sql API
The Sql API from Materialize — 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/materialize-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: Materialize HTTP Sql API
version: v1
description: 'Session-less HTTP API for executing SQL statements against a Materialize
region. Supports a simple mode (single query string) and an extended mode
(array of parameterized queries). Session-bound statements such as
SUBSCRIBE, DECLARE, FETCH, and COPY are not supported over HTTP.
'
contact:
name: Materialize
url: https://materialize.com
servers:
- url: https://{mz_host}
description: Materialize region host
variables:
mz_host:
default: REGION.materialize.com
description: The hostname of your Materialize region.
security:
- BasicAuth: []
tags:
- name: Sql
paths:
/api/sql:
post:
summary: Execute SQL statements
operationId: executeSql
parameters:
- in: query
name: options
required: false
schema:
type: string
description: 'URL-encoded JSON object of session configuration parameters
(e.g. `cluster`, `application_name`).
'
requestBody:
required: true
content:
application/json:
schema:
oneOf:
- $ref: '#/components/schemas/SimpleRequest'
- $ref: '#/components/schemas/ExtendedRequest'
responses:
'200':
description: Query results.
content:
application/json:
schema:
type: object
properties:
results:
type: array
items:
type: object
'400':
description: Bad request.
'401':
description: Authentication failed.
tags:
- Sql
components:
schemas:
ExtendedRequest:
type: object
required:
- queries
properties:
queries:
type: array
items:
type: object
required:
- query
properties:
query:
type: string
params:
type: array
items:
type:
- string
- 'null'
description: Positional parameters for the prepared query.
SimpleRequest:
type: object
required:
- query
properties:
query:
type: string
description: A SQL string (may contain multiple statements separated by semicolons).
securitySchemes:
BasicAuth:
type: http
scheme: basic
description: 'HTTP Basic authentication using your Materialize email as the username
and an app password as the password.
'