# DynamoSQL

> ANSI SQL query engine for Amazon DynamoDB

DynamoSQL is a managed SQL query engine that lets you run standard ANSI SQL SELECT queries directly on Amazon DynamoDB tables. It supports JOINs, CTEs (Common Table Expressions), aggregations, subqueries, ordering, and filtering — without requiring data export, ETL pipelines, or data warehouses.

## Key Facts

- Queries DynamoDB tables in place — no data movement or ingestion
- Supports ANSI SQL SELECT syntax including JOINs, CTEs, GROUP BY, ORDER BY, subqueries
- Index-aware query optimizer that respects DynamoDB's key structure and cost model
- SQL-over-HTTPS API for integration with apps and dashboards
- Security: IAM role-based access with temporary STS credentials; no long-lived keys
- DynamoSQL does not persist customer data
- Available on AWS Marketplace with pay-as-you-go pricing
- Developed by J&M Rapid Application Development, LLC

## Links

- Website: https://dynamosql.com
- Documentation: https://docs.dynamosql.com
- Application: https://app.dynamosql.com
- AWS Marketplace: https://aws.amazon.com/marketplace/pp/prodview-o2ddsn4oox2sy
- Contact: info@dynamosql.com

## How It Works

1. Subscribe on AWS Marketplace and create an account
2. Create an IAM role in your AWS account granting DynamoSQL read access to your DynamoDB tables
3. Run SQL queries via the DynamoSQL portal or REST API