免费在 GitHub 公开

drizzle-studio

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.

中文简介正在准备中。当前显示原文说明。

TerminalSkills/skills

集成工具PostgreSQL MySQL

查看安装方法

包含的文件（2）

SKILL.md3.1 KB
_scores.json1.8 KB

SKILL.md（原文）

安装前可以查看交给 AI 代理的指令内容。

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

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

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

// 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)

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

Start Drizzle Studio connected to the production database (read-only credentials).
Navigate to the users table.
Apply filters: created_at > yesterday AND email_verified = false.
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.

评价

还没有评价。欢迎分享你的使用感受。

无需登录即可发表。欢迎分享使用感受、提问，或说明在哪些环境下无法运行。

还没有评论。来写第一条吧。

同一仓库的技能

3dsmax-rendering

免费

Scripts and configures production rendering in Autodesk 3ds Max with the V-Ray and Corona renderers: output size and files, render elements, denoising, light mix, batch and command-line rendering, and network rendering. Use when a user asks to set up a production render, render several cameras in one batch, render from the command line or on a render farm, add render passes for compositing, or cut render time for archviz and product shots.

中文简介正在准备中。当前显示原文说明。