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

🚀 Quick Start

In your project root, run:

drizzle-setup

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

🔗 Try it Now

Ready to skip the boilerplate and get building?

npx drizzle-setup

💬 Have Feedback?

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