Skill4.9k estrellas del repoactualizado 5d ago

dump-schema

The dump-schema skill exports a PostgreSQL database schema from a local development database to a SQL file, stripping out comments, ownership details, and privilege information. Use this skill when you need a clean schema definition for version control, documentation, or sharing with team members without extraneous metadata.

Ver fuente Repositorio: macro

Instalar en Claude Code

Copiar

git clone --depth 1 https://github.com/macro-inc/macro /tmp/dump-schema && cp -r /tmp/dump-schema/.claude/skills/dump-schema ~/.claude/skills/dump-schema

Después abre una sesión nueva de Claude Code; el skill carga automáticamente.

Definición

SKILL.md

# Dump Schema

Dump a clean PostgreSQL schema (no comments, no ownership, no privileges) from the local dev database.

## Parameters

Ask the user (if not provided):
- **output_file** – absolute path for the `.sql` file (default: prompt user)

Use this database URL unless the user specifies otherwise:
```
postgres://user:password@localhost:5432/macrodb
```

## Steps

1. Run `pg_dump` with schema-only flags, pipe through cleanup, write to file:

```bash
pg_dump --schema-only --no-owner --no-privileges --no-comments --no-publications --no-subscriptions --no-security-labels --no-tablespaces "$DB_URL" | sed '/^--/d' | sed '/^SET /d' | sed '/^SELECT pg_catalog/d' | sed '/^$/N;/^\n$/d' > "$OUTPUT_FILE"
```

2. Copy the output path to the clipboard:

```bash
echo -n "$OUTPUT_FILE" | pbcopy
```

3. Report: `Schema dumped to <path> (path copied to clipboard)`

Del mismo repositorio

add-sdk-endpointSkill

Wrap a new backend endpoint in the TypeScript SDK (packages/sdk), or record it as skipped. Use when `just coverage` fails, or after adding an endpoint to a Rust service.

cloud-storage-hexagonal-architectureSkill

Enforce hexagonal architecture in the Rust backend. Use before modifying crates/ or Rust services, especially inbound axum/tool/listener adapters, domain services/ports, outbound adapters, authorization, permissions, database access, or external clients.

create-ai-toolSkill

Build a new AI tool end-to-end — Rust implementation, toolset wiring, infra, schema generation, and frontend UI.

debug-serviceSkill

dependabotSkill

Find all open Dependabot alerts for this repo and create a plan to resolve them using the appropriate package manager overrides (pnpm, bun, npm, cargo).

live-debugSkill

mintlifySkill

Build and maintain documentation sites with Mintlify. Use when creating docs pages, configuring navigation, adding components, or setting up API references.

mintlify-apiSkill

Interact with the Mintlify REST API to manage deployments, trigger builds, and query documentation site metadata programmatically.