🗄️ Drizzle Setup CLI

A powerful CLI tool that automatically scaffolds and configures database setup using Drizzle ORM for PostgreSQL, SQLite, MySQL, and more databases.

✨ Features

🚀 Zero Configuration Setup – Instantly scaffold database structure and config with minimal input
📜 Automated Script Generation – Automatically updates package.json with essential Drizzle CLI scripts
🔐 Environment Management – Automatically injects required environment variables into .env
🗃️ Multi-Database Support – Seamlessly works with PostgreSQL, SQLite, MySQL, and other popular databases
📁 Template System – Instantly sets up a working project structure with best practices
🎯 Interactive Setup – Guided CLI experience with smart defaults
📦 Dependency Management – Automatically installs required packages based on your database choice

🚀 Quick Start

Navigate to your project directory and run:

npx drizzle-setup

The CLI will guide you through an interactive setup process:

Setup Flow

🗄️ Database Selection – Choose from PostgreSQL, SQLite, MySQL, and more
⚙️ Configuration Preset – Select from optimized presets for different use cases
📁 Target Directory – Specify where to create your database files
📋 Template Selection – Choose from various boilerplate templates
🔧 Config Generation – Automatically create drizzle.config.ts
🔐 Environment Setup – Update .env with required variables
📦 Package Management – Install dependencies via your preferred package manager
✅ Final Verification – Ensure everything is set up correctly

🗃️ Supported Databases

PostgreSQL

Default PostgreSQL – Standard PostgreSQL setup
Neon – Serverless PostgreSQL with automatic scaling
Supabase – Open-source Firebase alternative
Vercel Postgres – Serverless PostgreSQL by Vercel

SQLite

Default SQLite – Local SQLite database
Turso – Edge SQLite database
Bun SQLite – High-performance SQLite with Bun runtime
Cloudflare D1 – Serverless SQLite at the edge

MySQL

Default MySQL – Standard MySQL setup
PlanetScale – Serverless MySQL platform
Railway MySQL – Cloud MySQL hosting

Other Databases

MongoDB – NoSQL document database
Redis – In-memory data structure store

Each database type comes with pre-configured templates, optimized settings, and environment variables.

🏗️ Project Structure

After setup, your project will have a clean, organized structure:

project-root/
├── node_modules/            # Installed dependencies
├── drizzle.config.ts        # Drizzle configuration
├── .env                     # Environment variables
├── .env.example             # Example environment file
├── package.json             # Updated with Drizzle scripts
├── [target-folder]/         # Your database folder
│   ├── schema.ts            # Database schema definitions
│   ├── index.ts             # Database connection and exports

Perfect for Modern Stacks 🏗️

This tool shines especially bright with modern frameworks:

🚀 Astro Projects

# In your Astro project
npx drizzle-setup
# Choose PostgreSQL + Vercel
# Boom! Database ready for your Astro app

⚡ Next.js Apps

# Perfect for Next.js API routes
npx drizzle-setup
# Select your preferred database
# Start building features, not configs

🎯 Any JavaScript/TypeScript Project

Whether it’s Express, Fastify, SvelteKit, or any other framework - this CLI has got you covered.

Real-World Impact 📈

Before Drizzle Setup CLI:

⏰ 2-3 hours of setup time
🐛 Configuration errors and typos
📚 Constant reference to documentation
😫 Frustration and context switching

After Drizzle Setup CLI:

⚡ 30 seconds to complete setup
✅ Zero configuration errors
🎯 Focus on building features
😊 Happy developer experience