HN Showcase
Back to browse
DynamoSQL – I made a SQL query engine for DynamoDB

DynamoSQL – I made a SQL query engine for DynamoDB

by cammasmith·Apr 14, 2026·1 point·0 comments
Visit ProjectView on HN

AI Analysis

●●SolidSolve My ProblemNiche GemSlick

ANSI SQL on DynamoDB without ETL pipelines or data movement to Athena.

Strengths
  • •Index-aware optimizer respects partition keys to minimize read costs.
  • •No data movement or ETL pipelines required to run JOINs.
  • •MCP support allows AI assistants to query DynamoDB data directly.
Weaknesses
  • •Pay-per-query pricing could get expensive compared to self-hosted Athena.
  • •Beta stage means potential stability risks for production analytics workloads.
Category
Data
Target Audience

Backend developers using AWS DynamoDB

Similar To

Amazon Athena · PartiQL · Trino

Post Description

As a software developer, I've frequently used DynamoDB, and I have found myself missing the ease of SQL querying. So I built DynamoSQL to be a SQL layer. It allows you to write standard ANSI SQL in DynamoDB, including JOINs across tables, CTEs, subqueries, GROUP BY, and aggregations. There's no ETL, data export, or separate warehouse. The optimizer is index-aware and uses your partition keys, sort keys, and GSIs to minimize read costs.

Ultimately, I'd like to list DynamoSQL on the AWS Marketplace as pay-per-query SaaS. But first, I want to make sure that it works properly. If you actively use DynamoDB and know a little SQL, would you consider becoming a beta tester for DynamoSQL? It's completely free during beta testing, and I'm just looking for criticism and critical feedback you might have so that I can make it better.

AWS Marketplace listing: https://aws.amazon.com/marketplace/pp/prodview-o2ddsn4oox2sy Beta tester page: https://dynamosql.com/beta

Happy to answer technical questions.

Similar Projects