Zero-Config DB Setup with Drizzle ORM Using drizzle-setup CLI
Dev Gaurav Jatt

Dev Gaurav Jatt @devgauravjatt

About: 😂 No need for another introduction javascript is All Rounder.

Location:
Dholpur and Jaipur, Rajasthan
Joined:
Jun 19, 2023

Zero-Config DB Setup with Drizzle ORM Using drizzle-setup CLI

Publish Date: Jun 7 '25
11 5

📚 Supercharge Your Drizzle ORM Workflow with drizzle-setup CLI

Setting up a modern ORM for your project should be fast, reliable, and flexible. That’s where drizzle-setup cli comes in — a powerful utility to automatically scaffold your Drizzle ORM setup for PostgreSQL, SQLite, MySQL, and more.

Whether you’re working on a side project or spinning up a production-ready stack, drizzle-setup ensures a frictionless experience from zero to fully-configured.


✨ Why Use drizzle-setup?

Here’s what makes this CLI a game-changer:

  • 📦 Zero Config Setup – Get started with just a few prompts.

  • 📜 Drizzle Scripts – Automatically populates your package.json with useful Drizzle CLI commands.

  • 🔧 .env Auto Update – Adds all essential environment variables without manual hassle.

  • 🧩 Multi-DB Support – Works with PostgreSQL, SQLite, MySQL, and more.

  • 📁 Template Copying – Sets up your schema.ts and index.ts instantly.


📦 Installation

You can install globally using your favorite package manager:

npm install -g drizzle-setup
# or use npx for one-time setup
npx drizzle-setup
Enter fullscreen mode Exit fullscreen mode

🚀 Quick Start

In your project root, run:

drizzle-setup
Enter fullscreen mode Exit fullscreen mode

You’ll be guided through:

  1. Selecting a database (PostgreSQL, SQLite, etc.)

  2. Choosing a preset config

  3. Setting the target folder

  4. Copying boilerplate files

  5. Generating drizzle.config.ts

  6. Updating .env and package.json

  7. Installing required dependencies


🧪 Supported Databases

  • PostgreSQL: Default, Neon, PlanetScale and more.

  • SQLite: Default, Turso, Bun SQLite and more.

  • MySQL: Default, Turso, Bun SQLite and more.

Each choice is tailored with optimal templates and .env configs.


🧱 Resulting Directory Structure

Once setup completes, your project might look like this:

project-root/
├── drizzle.config.ts
├── .env
├── [target-folder]/
│   ├── schema.ts
│   └── index.ts

Enter fullscreen mode Exit fullscreen mode

🔗 Try it Now

Ready to skip the boilerplate and get building?

npx drizzle-setup
Enter fullscreen mode Exit fullscreen mode

💬 Have Feedback?

Drop your suggestions or issues in the GitHub repo or tweet with the hashtag #DrizzleSetupCLI.


Comments 5 total

Add comment