drizzle-studio

Included with Lifetime

$97 forever

Explore and manage databases with Drizzle Studio. Use when a user asks to browse database contents visually, inspect tables and data, run ad-hoc queries, manage database records through a GUI, debug database issues, or use a lightweight alternative to pgAdmin or DBeaver. Covers setup with Drizzle ORM, standalone usage, data browsing, filtering, and inline editing.

Ads & Marketing

What this skill does

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

Files: 2

Size: 4.8 KB

Complexity: 17/100

Category: Ads & Marketing

Source: https://github.com/terminalskills/skills/tree/main/skills/drizzle-studio

Related in Ads & Marketing

Included

Multi-platform paid advertising audit and optimization skill. Analyzes Google, Meta, YouTube, LinkedIn, TikTok, Microsoft, and Apple Ads. 250+ checks with scoring, parallel agents, industry templates, and AI creative generation.

Ads & Marketingscriptsfeatured

banana

Included

AI image generation Creative Director powered by Google Gemini Nano Banana models. Use this skill for ANY request involving image creation, editing, visual asset production, or creative direction. Triggers on: generate an image, create a photo, edit this picture, design a logo, make a banner, visual for my anything, and all /banana commands. Handles text-to-image, image editing, multi-turn creative sessions, batch workflows, and brand presets.

Ads & Marketingscriptsfeatured

rpg-migration-analyzer

Included

Analyzes legacy RPG (Report Program Generator) programs from AS/400 and IBM i systems for migration to modern Java applications. Extracts business logic from RPG III/IV/ILE source code, identifies data structures (D-specs), file operations (F-specs), program dependencies (CALLB/CALLP), and converts RPG constructs to Java equivalents. Generates migration reports, complexity estimates, and Java implementation strategies with POJO classes, JPA entities, and service methods. Use when modernizing AS/400 or IBM i legacy systems, analyzing RPG source files (.rpg, .rpgle, .RPGLE), converting RPG to Java, mapping data specifications to Java classes, planning legacy system migration, or when user mentions RPG analysis, Report Program Generator, RPG III/IV/ILE, AS/400 modernization, IBM i migration, packed decimal conversion, or mainframe application rewrite.

Ads & Marketingscripts

brand-library-architect

Included

Build a complete brand library for a product — visual asset render pipeline, brand documentation set (BRAND, COPY, MANIFESTO, BIOS, FAQ, GLOSSARY, TONE, PRICING), open-source convention files (README, CONTRIBUTING, SECURITY, CODE_OF_CONDUCT), and a self-contained press kit. This skill should be used when the user asks to "build a brand library / brand kit / press kit / brand assets" for a product, "set up a brand library workflow," "create a positioning manifesto plus visual identity," or any combination of brand documentation + visual asset pipeline. Apply phase-by-phase or run end-to-end. Templates are product-agnostic and use {{TOKEN}} placeholders the skill prompts the user to fill.

Ads & Marketingscripts

writing-tech-post

Included

Authors engineering blog posts end-to-end: launch deep-dives, incident postmortems, architecture migrations, performance case studies, tutorials, AI/agent system writeups, security disclosures, and research-to-product translations. Picks the correct archetype, plans the abstraction ladder, enforces an evidence cadence (diagrams, benchmarks, profiles, traces, code, ablations), tunes voice against publisher house styles (Datadog, Vercel, GitHub, AWS, Meta, Cloudflare, Jane Street), and runs a pre-publish gate for narrative momentum and disclosure ethics. Use when drafting a new engineering post, restructuring a draft that feels flat, deciding which evidence form belongs where, validating that depth and product context are balanced, or preparing a postmortem, migration, or performance narrative for external publication. Do not use for API reference documentation, README authoring, marketing copy, release notes, generic SEO content, ghost-written executive thought leadership, or non-engineering long-form essays.

Ads & Marketingscripts

blog-google

Included

Google API integration for blog performance: PageSpeed Insights, CrUX Core Web Vitals with 25-week history, Search Console performance, URL Inspection, Indexing API, GA4 organic traffic, NLP entity analysis for E-E-A-T, YouTube video search for embedding, and Google Ads Keyword Planner. Progressive feature availability based on credential tier (API key, OAuth/service account, GA4, Ads). Shares config with claude-seo at ~/.config/claude-seo/google-api.json. Use when user says "google data", "page speed", "core web vitals", "search console", "indexation", "GA4", "keyword research", "nlp entities", "blog performance", "youtube search", "google api setup".

Ads & Marketingscripts

Included

Ads & Marketingscriptsfeatured