Ways to query
There are several ways to run SQL against your workspace:- REST API: send a query to the Query SQL endpoint and get results back as JSON.
- MCP: the
query-particle-sqltool lets AI tools run SQL on your behalf, for natural-language analytical questions. - Data connectors: generate database credentials to query your workspace data from external tools.
Available data
Workspace data is exposed as SQL tables across two queryable schemas:objects (one table per object) and lists (one table per list entry). See Available data for what’s queryable today and how to discover the schema.
Limitations
- Read-only: only
SELECTis supported.INSERT,UPDATE,DELETE, and DDL statements are rejected. - Query timeout: the Query SQL endpoint has a 30-second execution timeout, so very complex queries may fail.
- Rate limits: the Query SQL endpoint and
query-particle-sqlMCP tool are subject to rate limits.
Next steps
- Available data — the schemas and tables you can query, and how to discover them.
- Querying with SQL — guidance for writing queries including worked examples.
- Data connectors — create a data connector to query your workspace data from external tools over the PostgreSQL protocol.