DEV Community

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

Posted on

2 3 2 3 1

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

📚 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.


Warp.dev image

The best coding agent. Backed by benchmarks.

Warp outperforms every other coding agent on the market, and gives you full control over which model you use. Get started now for free, or upgrade and unlock 2.5x AI credits on Warp's paid plans.

Download Warp

Top comments (3)

Collapse
 
dotallio profile image
Dotallio

Zero-config for Drizzle ORM is something I’ve definitely been wishing for. How does it hold up when switching between multiple DB environments in the same project?

Collapse
 
devgauravjatt profile image
Dev Gaurav Jatt

v0.0.5

✨ feat(env): add support for multiple .env files

  • implemented support for updating multiple .env* files
  • added functionality to create a default .env file if none exist
  • improved handling of existing environment variables to avoid overwriting
  • enhanced error handling and logging for robustness
  • added glob package for file searching
  • updated documentation to reflect changes
Collapse
 
devgauravjatt profile image
Dev Gaurav Jatt

Some comments may only be visible to logged-in visitors. Sign in to view all comments.

Feature flag article image

Create a feature flag in your IDE in 5 minutes with LaunchDarkly’s MCP server ⏰

How to create, evaluate, and modify flags from within your IDE or AI client using natural language with LaunchDarkly's new MCP server. Follow along with this tutorial for step by step instructions.

Read full post

👋 Kindness is contagious

Discover fresh viewpoints in this insightful post, supported by our vibrant DEV Community. Every developer’s experience matters—add your thoughts and help us grow together.

A simple “thank you” can uplift the author and spark new discussions—leave yours below!

On DEV, knowledge-sharing connects us and drives innovation. Found this useful? A quick note of appreciation makes a real impact.

Okay