npm install @hypequery/clickhouseBuild Type-Safe ClickHouse Dashboards
Build powerful ClickHouse dashboards with complete type safety. Our TypeScript SDK gives you the perfect balance of power and simplicity.
The Challenge
ClickHouse queries, meet type safety
Without types, ClickHouse queries are error-prone. String concatenation leads to SQL injection risks. Runtime errors cause production issues. And the disconnect between queries and result types wastes developer time.
The Solution
A type-safe query builder designed for developers
hypequery provides a fluent, type-safe API that makes working with ClickHouse a joy. Say goodbye to SQL strings and hello to autocomplete, runtime safety, and developer productivity.
// Type-safe column selection
builder
.table('users')
.select(['id', 'name', 'email']) // ✓ Type checked!
.select(['not_a_column']) // ✗ Type error!
// Type-safe filtering
builder
.table('users')
.where('age', 'gt', 18) // ✓ Type checked!
.where('age', 'gt', 'string') // ✗ Type error!
// Type-safe results
const users = await builder.table('users').execute();
console.log(users[0].name); // ✓ Type checked!
console.log(users[0].not_a_prop); // ✗ Type error!Features that spark joy ✨
Everything you need for ClickHouse development
- Complete Type Safety
-
Every part of your query is type-checked - from table and column names to filter values and result types.
- Flexible Join System
-
Easily create powerful joins with a fluent API. Set up relationship definitions for even more convenience.
- SQL Expressions & Functions
-
Use raw SQL expressions and ClickHouse functions when you need them, while maintaining type safety.
- Streaming Support
-
Process large result sets efficiently with built-in support for Clickhouse query streaming
- Advanced Filtering
-
Define and apply cross filters to multiple queries with ease.
- Comprehensive Logging
-
Track query execution with detailed logs of queries, parameters, timing, and row counts.
Ready to build with type safety?
Get started with our TypeScript SDK today and transform how you work with ClickHouse.