DynamoSQL™

DynamoSQL is a SQL query engine that runs ANSI SQL directly on Amazon DynamoDB tables. It addresses the difficulties of performing analytical queries on DynamoDB data by eliminating the need for data exports, ETL pipelines, duplicate storage, or additional infrastructure.

The engine supports full ANSI SQL SELECT queries, including JOINs, CTEs, aggregations, subqueries, filtering, ordering, and LIMIT clauses. An index-aware optimizer designs query plans around DynamoDB keys and indexes to reduce scans and control costs. A SQL-over-HTTPS REST API allows integration into applications, dashboards, and internal tools. The service also provides a web-based portal and SQL workspace for browsing schemas, inspecting tables, and running queries interactively without code or API configuration. All operations are read-only, with write actions handled through DynamoDB native APIs.

DynamoSQL operates with no data movement, querying tables in place. Security relies on IAM roles that grant temporary credentials via AWS STS, ensuring data remains in the user's AWS account without persistence by the engine. Every action is logged through AWS CloudTrail for auditability. It includes MCP compatibility to connect AI assistants such as Claude or Cursor for conversational schema discovery and SQL generation.

The service is delivered as a cloud-based offering available through AWS Marketplace. Users subscribe there, create an IAM role with read permissions on target DynamoDB tables, and access the portal or API. Pricing follows a pay-as-you-go model with the first 500 queries free and subsequent usage billed per query through the AWS account, with no upfront costs or monthly minimums.