Sold by: DynamoSQL
Deployed on AWS
DynamoSQL is an ANSI SQL query engine for Amazon DynamoDB. Run JOINs, CTEs, aggregations, subqueries, and GROUP BY directly on your DynamoDB tables - no ETL pipelines, no data export, no infrastructure to
manage. Query via a web console or SQL-over-HTTPS API with IAM-based access, temporary credentials, and full CloudTrail auditability.
Overview
DynamoSQL is an ANSI SQL query engine purpose-built for Amazon DynamoDB. It lets engineers, analysts, and ops teams run standard SQL - including JOINs, CTEs, GROUP BY, subqueries, aggregations, and ORDER BY - directly on DynamoDB tables without exporting data, building ETL pipelines, or maintaining a separate data warehouse. Define schema mappings for your tables once, then query through a web console or a SQL-over-HTTPS REST API. DynamoSQL's optimizer is index-aware, using your DynamoDB partition keys, sort keys, and GSIs to minimize read costs and latency.
Security and governance are built into every layer. Each connection is scoped to a specific AWS account, region, IAM role, external ID, and explicit table allowlist - you control exactly what DynamoSQL can access. All queries use short-lived AWS STS credentials (AssumeRole), and every DynamoDB API call is logged in your CloudTrail for full auditability. DynamoSQL does not store or persist your data.
DynamoSQL is available as a pay-as-you-go SaaS subscription through AWS Marketplace - no upfront commitments, no infrastructure to provision. Subscribe, grant access via an IAM role, and start querying in minutes.
Try it free: your first 500 queries are included at no cost. After that, pricing is usage-based and typically amounts to a fraction of a cent per query, based on DynamoDB read units.
Highlights
- Query DynamoDB with full ANSI SQL - Run JOINs (inner, outer, cross), CTEs, subqueries, GROUP BY, ORDER BY, aggregations, and expressions directly on your DynamoDB tables. No data export, no ETL pipelines, no PartiQL limitations. DynamoSQL's index-aware optimizer uses your partition keys, sort keys, and GSIs to minimize read costs.
- Web console and SQL-over-HTTPS API - Query interactively through a built-in portal or integrate programmatically via a REST API. Define schema mappings once and reuse them across dashboards, internal tools, scripts, and automated workflows. Pay-as-you-go through AWS Marketplace with no infrastructure to provision.
- Secure by design with full AWS-native controls - Access is scoped per tenant using IAM roles, external IDs, and explicit table allowlists. All queries use short-lived STS credentials and every DynamoDB API call is logged in your CloudTrail. DynamoSQL does not persist customer data.
Details
Sold by
Categories
Delivery method
Deployed on AWS
New
Introducing multi-product solutions
You can now purchase comprehensive solutions tailored to use cases and industries.
Features and programs
Financing for AWS Marketplace purchases
AWS Marketplace now accepts line of credit payments through the PNC Vendor Finance program. This program is available to select AWS customers in the US, excluding NV, NC, ND, TN, & VT.
Pricing
Pricing is based on actual usage, with charges varying according to how much you consume. Subscriptions have no end date and may be canceled any time.
Additional AWS infrastructure costs may apply. Use the AWS Pricing Calculator to estimate your infrastructure costs.
Dimension | Description | Cost/unit |
|---|---|---|
Query Units | Metered usage units for SQL query execution in DynamoSQL. First 500 Queries are free. | $0.001 |
Dimensions summary
You pay based on usage, measured in Query Units. Each SQL query you run against your DynamoDB tables counts toward your metered usage. Your first 500 queries are free. After that, you pay only for the queries you run, with no upfront cost and no monthly minimum. This is a single usage-based dimension, so charges scale directly with query volume. Note that validating queries in plan mode does not fetch data. Separately, DynamoDB read capacity used by your queries is charged to your own AWS account and is not billed here.
Top-of-mind questions for buyers
A Query Unit maps to one SQL query you run in execute mode against your DynamoDB tables. Each query you execute counts toward metered usage. Queries run in plan mode only validate and optimize the statement without fetching data, so they do not consume DynamoDB read capacity.
There are no artificial row limits beyond the pagination parameter, which defaults to 100 rows per request. You can raise it per request or page through full results. Billing counts queries, not rows returned. Note that stateless pagination re-executes the query on each page request.
No. This engine is read-only and supports SELECT statements only. INSERT, UPDATE, DELETE, and schema changes are not supported, so they cannot be billed here. Writes remain in DynamoDB through its native APIs. Only SELECT queries you execute count as metered Query Units.
dynamosql.com+3
Helpful?
Vendor refund policy
DynamoSQL is billed pay-as-you-go through AWS Marketplace with no upfront fees or commitments. Charges reflect only the queries executed during each billing period.
If you believe you were charged in error, contact info@dynamosql.com within 30 days. We will review the request and issue a refund if a billing error is confirmed. Refunds are not available for usage that was successfully processed. You may cancel your subscription at any time. No further charges will be incurred after cancellation.
Legal
Vendor terms and conditions
Upon subscribing to this product, you must acknowledge and agree to the terms and conditions outlined in the vendor's End User License Agreement (EULA) .
Content disclaimer
Vendors are responsible for their product descriptions and other product content. AWS does not warrant that vendors' product descriptions or other product content are accurate, complete, reliable, current, or error-free.
Delivery details
Software as a Service (SaaS)
SaaS delivers cloud-based software applications directly to customers over the internet. You can access these applications through a subscription model. You will pay recurring monthly usage fees through your AWS bill, while AWS handles deployment and infrastructure management, ensuring scalability, reliability, and seamless integration with other AWS services.
Support
Vendor support
Email support: support@dynamosql.com
DynamoSQL customers receive email-based technical support for account setup, IAM role configuration, schema mapping, query troubleshooting, and API integration. Support requests are typically acknowledged within one business day. Product documentation is available at
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.
Customer reviews
No customer reviews yet
Be the first to review this product . We've partnered with PeerSpot to gather customer feedback. You can share your experience by writing or recording a review, or scheduling a call with a PeerSpot analyst.