# DynamoSQL

## Docs

- [Authentication](https://docs.dynamosql.com/api-reference/authentication.md): Obtain and refresh bearer tokens for API access.
- [Get Access Token](https://docs.dynamosql.com/api-reference/authentication/get-token.md): Exchange API client credentials for a bearer token.
- [Refresh Access Token](https://docs.dynamosql.com/api-reference/authentication/refresh-token.md): Exchange a refresh token for a new access token.
- [Query](https://docs.dynamosql.com/api-reference/query.md): Run or plan SQL queries against DynamoDB.
- [Create Schema](https://docs.dynamosql.com/api-reference/schemas/create.md): Connect DynamoSQL to DynamoDB tables in your AWS account.
- [Delete Schema](https://docs.dynamosql.com/api-reference/schemas/delete.md): Permanently delete a schema and its cached metadata.
- [Get Schema](https://docs.dynamosql.com/api-reference/schemas/get.md): Retrieve a schema by name.
- [List Schemas](https://docs.dynamosql.com/api-reference/schemas/list.md): List all schemas for your tenant.
- [Refresh Metadata](https://docs.dynamosql.com/api-reference/schemas/refresh-metadata.md): Refresh the cached DynamoDB table metadata for a schema.
- [Update Schema](https://docs.dynamosql.com/api-reference/schemas/update.md): Update a schema's connection details, table allowlist, or status.
- [Validate Role](https://docs.dynamosql.com/api-reference/schemas/validate-role.md): Verify that the schema's IAM role can be assumed and has DynamoDB access.
- [Usage Summary](https://docs.dynamosql.com/api-reference/usage.md): Query metered usage — requests, rows returned, and DynamoDB read units.
- [2026 Changelog](https://docs.dynamosql.com/changelog/2026.md): DynamoSQL release history for 2026.
- [Authentication](https://docs.dynamosql.com/guides/authentication.md): Principal types, scopes, and token lifecycle.
- [Error Handling](https://docs.dynamosql.com/guides/error-handling.md): Interpret error responses and handle failures gracefully.
- [IAM Setup](https://docs.dynamosql.com/guides/iam-setup.md): Grant DynamoSQL read access to your DynamoDB tables by creating a schema in the portal.
- [Pagination](https://docs.dynamosql.com/guides/pagination.md): Loop through large result sets using stateless offset pagination.
- [Postman Collection](https://docs.dynamosql.com/guides/postman.md): Import the DynamoSQL API into Postman
- [Query Modes](https://docs.dynamosql.com/guides/query-modes.md): Understand the difference between execute and plan mode.
- [Quickstart](https://docs.dynamosql.com/guides/quickstart.md): Get your first query running in under 5 minutes.
- [Rate Limits and Quotas](https://docs.dynamosql.com/guides/rate-limits-and-quotas.md): Per-tenant metering, DynamoDB capacity, and usage tracking.
- [Response Formats](https://docs.dynamosql.com/guides/response-formats.md): Choose between row arrays and key-value objects.
- [MCP Authentication](https://docs.dynamosql.com/mcp/authentication.md): OAuth flows for human users and API clients on the DynamoSQL MCP server.
- [Overview](https://docs.dynamosql.com/mcp/overview.md): Connect AI assistants to your DynamoDB data with the DynamoSQL MCP server.
- [MCP Quickstart](https://docs.dynamosql.com/mcp/quickstart.md): Connect your AI assistant to DynamoDB data in under 5 minutes.
- [Tools and Resources](https://docs.dynamosql.com/mcp/tools-and-resources.md): Complete reference for DynamoSQL MCP tools, resources, and prompts.
- [Expressions and Operators](https://docs.dynamosql.com/sql-reference/expressions-and-operators.md): Arithmetic, bitwise, string, CASE, and conditional expressions.
- [FROM and JOINs](https://docs.dynamosql.com/sql-reference/from-and-joins.md): Table references, aliases, subqueries in FROM, and all join types.
- [Functions](https://docs.dynamosql.com/sql-reference/functions.md): Built-in numeric, string, conditional, and aggregate functions.
- [Grouping and Aggregation](https://docs.dynamosql.com/sql-reference/grouping-and-aggregation.md): GROUP BY, HAVING, and aggregate functions.
- [Limitations](https://docs.dynamosql.com/sql-reference/limitations.md): Current hard limits and unsupported SQL features.
- [SQL Reference Overview](https://docs.dynamosql.com/sql-reference/overview.md): What SQL DynamoSQL supports today.
- [SELECT](https://docs.dynamosql.com/sql-reference/select.md): Column selection, aliases, DISTINCT, ORDER BY, and LIMIT.
- [Set Operations](https://docs.dynamosql.com/sql-reference/set-operations.md): UNION, UNION ALL, EXCEPT, EXCEPT ALL, INTERSECT, and INTERSECT ALL.
- [Subqueries and CTEs](https://docs.dynamosql.com/sql-reference/subqueries-and-ctes.md): WITH clauses, scalar subqueries, correlated subqueries, and derived tables.
- [WHERE Predicates](https://docs.dynamosql.com/sql-reference/where-predicates.md): Filter rows with comparisons, BETWEEN, IN, EXISTS, LIKE, IS NULL, and more.

## OpenAPI Specs

- [openapi](https://docs.dynamosql.com/openapi.yaml)