Can I use this for serverless or edge deployments?

Yes, the Hono adapter is specifically designed to work with edge runtimes like Cloudflare Workers and Bun.

What API endpoints does the server setup provide?

The adapters expose standard Cube.js-compatible endpoints: /load for data fetching, /sql for query generation, and /meta for schema metadata.

Do I need to manually initialize the semantic layer compiler?

No, the adapters create the semantic layer compiler internally using the array of cube definitions you provide during initialization.

How does Drizzle Cube handle multi-tenancy?

It uses an 'extractSecurityContext' function within the adapter configuration to pull organization or user IDs from the request, ensuring data isolation.

Which web frameworks are supported by this skill?

The skill provides detailed setup instructions and adapters for Express, Fastify, Hono, and Next.js (including the App Router).

Drizzle Cube Server Setup

Name: Drizzle Cube Server Setup
Author: cliftonc

bycliftonc

API Development

Configures Drizzle Cube API servers across Express, Fastify, Hono, and Next.js to expose Cube.js-compatible semantic layer endpoints.

About

This skill streamlines the integration of Drizzle Cube into modern web frameworks by providing standardized adapters for setting up API servers. It enables developers to quickly expose Cube.js-compatible /load, /sql, and /meta endpoints while handling complex tasks like security context extraction and internal semantic layer compilation directly from cube definitions. Whether deploying to traditional Node.js environments or edge runtimes like Cloudflare Workers, this skill ensures a consistent, secure, and production-ready setup for your semantic layer API.

Key Features

Multi-framework support for Express, Fastify, Hono, and Next.js
Standardized Cube.js-compatible REST API endpoints (/load, /sql, /meta)
Integrated security context extraction for robust multi-tenant applications
Automated semantic layer compiler initialization from Drizzle cube arrays
Support for edge runtimes and modern authentication middlewares like JWT and NextAuth
0 GitHub stars

Use Cases

Building a multi-tenant analytics API with Drizzle ORM and Express or Fastify
Deploying a serverless semantic layer using Hono on Cloudflare Workers
Integrating Cube.js-compatible data endpoints into a Next.js App Router project

About

Key Features

Multi-framework support for Express, Fastify, Hono, and Next.js
Standardized Cube.js-compatible REST API endpoints (/load, /sql, /meta)
Integrated security context extraction for robust multi-tenant applications
Automated semantic layer compiler initialization from Drizzle cube arrays
Support for edge runtimes and modern authentication middlewares like JWT and NextAuth
0 GitHub stars

Use Cases

Building a multi-tenant analytics API with Drizzle ORM and Express or Fastify
Deploying a serverless semantic layer using Hono on Cloudflare Workers
Integrating Cube.js-compatible data endpoints into a Next.js App Router project