---
name: drizzle-studio
description: "\ud83e\udde0 The right skill, one API call. AI agent skills registry with token-efficient skill resolution. 5,000+ skills from 500+ top repos."
---

# Drizzle Studio

## Overview

Drizzle Studio is a visual database browser and admin tool that runs in your browser. Unlike heavyweight tools like pgAdmin or DBeaver, it starts in one command and works with any Drizzle ORM project. Browse tables, filter data, edit records inline, run SQL queries, and inspect relationships — all through a clean web interface. It supports PostgreSQL, MySQL, and SQLite.

## Instructions

### Step 1: Setup with Drizzle ORM

```bash
# If you already have a Drizzle ORM project:
npx drizzle-kit studio

# Opens http://localhost:4983
# Reads your drizzle.config.ts for database connection
```

```typescript
// drizzle.config.ts — Configuration that Studio reads
import { defineConfig } from 'drizzle-kit'

export default defineConfig({
  schema: './src/db/schema.ts',
  driver: 'pg',
  dbCredentials: {
    connectionString: process.env.DATABASE_URL!,
  },
})
```

### Step 2: Standalone Usage (Without Drizzle ORM)

```bash
# Connect to any PostgreSQL database
npx drizzle-kit studio --host 0.0.0.0 --port 4983

# With explicit connection
DATABASE_URL=postgresql://user:pass@localhost:5432/mydb npx drizzle-kit studio
```

### Step 3: Features

**Data browsing:**
- View all tables and their schemas
- Browse rows with pagination
- Filter by column values
- Sort by any column
- View relationships between tables

**Inline editing:**
- Click any cell to edit its value
- Add new rows directly in the UI
- Delete rows with confirmation
- Changes are applied to the database immediately

**SQL runner:**
- Execute arbitrary SQL queries
- View results in a table format
- Export results

## Examples

### Example 1: Debug production data issues
**User prompt:** "I need to quickly inspect the users table and find all accounts created in the last 24 hours that haven't verified their email."

The agent will:
1. Start Drizzle Studio connected to the production database (read-only credentials).
2. Navigate to the users table.
3. Apply filters: `created_at > yesterday` AND `email_verified = false`.
4. Review the results and export if needed.

## Guidelines

- Use read-only database credentials when browsing production data to prevent accidental modifications.
- Drizzle Studio is designed for development and debugging — for production admin panels, build a proper admin UI with access controls.
- It reads your `drizzle.config.ts` automatically — ensure the config points to the correct database for the environment you want to inspect.


---
Source attribution: TerminalSkills
Original project: https://github.com/TerminalSkills/skills
License: MIT
License information: https://opensource.org/license/mit
Original upstream instructions; downloaded from Dave AI.

## Upstream license notice

MIT License

Copyright (c) 2026 SkillsHub Contributors

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
SOFTWARE.



# Dave AI resource metadata

Creator / publisher: TerminalSkills
Original project: https://github.com/TerminalSkills/skills
Attribution basis: Original repository namespace preserved by package mirror

Fields of work: Data & Analytics, Development & Engineering, Product Management
Roles: Backend Developer, Data Analyst, Database Administrator, Product Manager, Technical Product Manager
Specialties: Backend, Database
Tools: MySQL, PostgreSQL, SQLite
Country applicability: Country not specified
Classification basis: Source catalog labels
Instruction SHA-256: 07d80f97c2ad2c706cfc1383fb823f6fbd73967ade9570c4554c03eac8482224
Metadata reviewed: 2026-10-27
This metadata supersedes earlier Dave AI catalog attribution. Original instruction and supporting files are preserved.