Skip to main content
The /v1/query endpoint is the core of DynamoSQL. Send a SQL SELECT statement and receive either a full result set or a query plan, depending on the mode you choose. The interactive playground below lets you send requests directly from the browser. Paste your bearer token into the auth field to authenticate.

​
Before You Start

  • See Query Modes for when to use execute vs plan and what each response field means.
  • See Pagination for how to page through large result sets using maxRows and resumeIdx.
  • See Response Formats to choose between row arrays and key-value objects.
  • See the SQL Reference for the full list of supported SQL features and current limitations.

​
Authentication

All requests require a bearer token issued by the DynamoSQL Cognito user pool via the client credentials grant. Pass it in the Authorization header: 
Authorization: Bearer YOUR_ACCESS_TOKEN
The required scope depends on the mode:
ModeRequired scope
executequery:execute
planquery:plan