Sumak
Sumak: A free, open-source query builder for TypeScript teams that need compiled SQL and introspection. Ranked #33 of 51 in Database Query Builders by our editors (5.7/10); pricing: Free plan; best for typeScript teams needing compiled queries and introspection.
At a glance
- Editor score5.7 / 10
- PricingFree plan
- Best forTypeScript teams needing compiled queries and introspection
- Free planYes
- Paid fromNone
- Type safetyStatic
- Facts checked4 Oct 2026
Where it wins
- Build type-checked queries for common SQL operations
- Compile SQL for PostgreSQL, MySQL, SQLite, and MSSQL
- Generate schema DDL and introspect databases
Where it doesn't
- Asynchronous execution requires a supplied database driver
- Raw SQL escape hatches allow expressions outside the typed builder
- Focused on TypeScript rather than multiple programming languages
Our verdict on Sumak
Sumak is a free, open-source TypeScript SQL query builder for teams that want a chainable way to define tables and construct database queries. Its static type checking covers common operations, including SELECT, INSERT, UPDATE, and DELETE. The project also supports joins, subqueries, common table expressions, transactions, and schema tools, making it relevant to small and mid-market TypeScript teams building applications around relational databases.
Its AST-based compiler generates SQL for PostgreSQL, MySQL, SQLite, and Microsoft SQL Server. Developers can compile queries without a database driver, while supplying a driver enables optional asynchronous execution. Reusable compiled queries use parameter placeholders; raw SQL tagged templates and unsafe expressions provide escape hatches when the builder does not express a needed query. Plugin and hook APIs can transform queries and results. This combination suits teams that want typed construction alongside control over generated SQL, though raw expressions require care outside the guarantees of the typed builder.
Schema DDL generation and database introspection extend Sumak beyond query construction, and the MIT license makes it an option for teams seeking open-source tooling. Its fit is strongest for TypeScript codebases that value static typing, compiled queries, and schema inspection across its supported dialects. Teams looking for a database-independent, multi-language query layer should consider alternatives, as Sumak is specifically a TypeScript project. Those needing asynchronous database access should also account for providing a driver; without one, the described workflow generates SQL rather than executing queries.
Your product? Our editors can test Sumak in depth and publish a review, labelled as paid · from $99/mo →
Sumak pricing
Sumak fact sheet
| Free plan | Yes |
|---|---|
| Paid from | None |
| Languages | TypeScript |
| SQL dialects | PostgreSQL, MySQL, SQLite, MSSQL |
| Type safety | Static |
| Async queries | Yes |
| Raw SQL support | Yes |
| Compile without execution | Yes |
| Deployment | Cloud |
| Platforms | Web |
| Built for | Small business, Mid-market (editorial estimate) |
| Pricing | Free plan |
| Website | github.com |
| Facts checked | 4 Oct 2026 |
Alternatives to Sumak
- jOOQA fluent SQL framework for JVM teams that want generated, type-safe database access.9.3
- SQLAlchemySQL construction, ORM, and database services for Python applications.9.1
- JetBrains ExposedA free, open-source Kotlin library with a type-safe SQL DSL and JDBC and R2DBC access.9.0
Used Sumak? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Sumak for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
Sumak is listed in our Database Query Builders directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/sumak/"><img src="https://www.itechguides.com/best/badge/sumak.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. How we rank.
Last updated · How we research and update