🐲 Drizzle Cube

Drizzle ORM-first semantic layer with Cube.js compatibility

Transform your Drizzle schema into a powerful, type-safe analytics platform with SQL injection protection and full TypeScript support.

📖 Documentation 🚀 Try the Sandbox

Why Drizzle Cube?

🔒 SQL Injection Proof - All queries use Drizzle's parameterized SQL
🛡️ Type Safe - Full TypeScript inference from your database schema
⚡ Performance - Prepared statements and query optimization
🧩 Cube.js Compatible - Works with existing Cube.js React components
🎯 Zero Config - Infer cube definitions from your Drizzle schema

Quick Start

1. Install

npm install drizzle-cube drizzle-orm

2. Define Your Schema

// schema.ts
import { pgTable, text, integer, boolean } from 'drizzle-orm/pg-core'

export const employees = pgTable('employees', {
  id: integer('id').primaryKey(),
  name: text('name').notNull(),
  email: text('email'),
  active: boolean('active').default(true),
  department: integer('department'),
  organisation: integer('organisation').notNull()
})

export const departments = pgTable('departments', {
  id: integer('id').primaryKey(),
  name: text('name').notNull(),
  organisation: integer('organisation').notNull()
})

export const schema = { employees, departments }

3. Create Type-Safe Cubes

// cubes.ts
import { defineCube } from 'drizzle-cube/server'
import { eq } from 'drizzle-orm'
import { schema } from './schema'

export const employeesCube = defineCube('Employees', {
  sql: (ctx) => ({
    from: schema.employees,
    where: eq(schema.employees.organisation, ctx.securityContext.organisationId)
  }),
  
  dimensions: {
    name: {
      name: 'name',
      title: 'Employee Name',
      type: 'string',
      sql: schema.employees.name
    },
    email: {
      name: 'email',
      title: 'Email',
      type: 'string',
      sql: schema.employees.email
    }
  },
  
  measures: {
    count: {
      name: 'count',
      title: 'Total Employees',
      type: 'count',
      sql: schema.employees.id
    }
  }
})

4. Setup API Server

// server.ts (Hono example)
import { Hono } from 'hono'
import { drizzle } from 'drizzle-orm/postgres-js'
import { createCubeApp } from 'drizzle-cube/adapters/hono'
import postgres from 'postgres'
import { schema } from './schema'
import { employeesCube } from './cubes'

const db = drizzle(postgres(process.env.DATABASE_URL!), { schema })

const app = createCubeApp({
  cubes: [employeesCube],
  drizzle: db,
  schema,
  getSecurityContext: async () => ({
    organisationId: 1 // Your auth logic here
  })
})

export default app

5. Query from Frontend

// Use built-in React components
import { QueryBuilder, AnalyticsDashboard } from 'drizzle-cube/client'

function App() {
  return (
    <div>
      <QueryBuilder apiUrl="/cubejs-api/v1" />
      <AnalyticsDashboard 
        config={dashboardConfig} 
        baseUrl="/cubejs-api/v1" 
      />
    </div>
  )
}

Key Features

🔒 SQL Injection Proof - All queries use Drizzle's parameterized SQL
🛡️ Type Safe - Full TypeScript inference from your database schema
⚡ Performance - Prepared statements and query optimization
🧩 Cube.js Compatible - Works with existing Cube.js React components
🎯 Zero Config - Infer cube definitions from your Drizzle schema

Supported Features

✅ Multiple Database Types - PostgreSQL, MySQL
✅ Framework Adapters - Hono, Express, Fastify, Next.js
✅ Full Type Safety - Complete TypeScript inference
✅ All SQL Features - Joins, CTEs, subqueries, window functions
✅ Cube.js Compatibility - Drop-in replacement for existing apps

Documentation

• 📚 Full Documentation - Complete guides and API reference
• 🚀 Try the Sandbox - Working example version to experiment with

Local Development

npm run dev

Examples

• Hono Example - Full-featured dashboard with Cloudflare Workers support
• Express Example - Simple Express.js server with React dashboard
• Fastify Example - High-performance Fastify server with React client
• Next.js Example - Full-stack Next.js app with API routes

Contributing

We welcome contributions! Please see our Contributing Guide.

Roadmap

• 🔄 Pre-aggregations - Materialized view support
• 🔄 Real-time Updates - WebSocket support
• 🔄 Query Caching - Redis integration

License

MIT © Clifton Cunningham

---

Built with ❤️ for the Drizzle ORM community