菜单
Use when running database migrations, creating new migrations, regenerating the GraphQL schema from PostgreSQL, regenerating TypeScript types, or querying the database directly. Trigger when the user mentions migrations, dbmate, schema changes, codegen, or any database operation.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
Use when starting, stopping, or managing the GoLinks development environment. Covers Docker Compose setup, running the Next.js dev server with LAN-accessible networking, and environment variable configuration. Trigger when the user asks to start the app, spin up a fresh environment, or needs to access the app from their laptop.
Use when managing the GoLinks production deployment on Fly.io. Covers viewing logs, checking status, deploying, and SSH access. Trigger when the user asks about production, deployment, Fly.io, or checking live app status.
Use when testing the GoLinks application after code changes. Covers linting, type checking, unit tests, and visual verification with Playwright headless browser. Trigger when the user asks to verify changes, run tests, check if something works, or test in the browser.
基于 SOC 职业分类
| name | golinks-database |
| description | Use when running database migrations, creating new migrations, regenerating the GraphQL schema from PostgreSQL, regenerating TypeScript types, or querying the database directly. Trigger when the user mentions migrations, dbmate, schema changes, codegen, or any database operation. |
# Run all pending migrations
DATABASE_URL=postgres://dev:dev@127.0.0.1:5432/golinks?sslmode=disable dbmate up
# Check migration status
DATABASE_URL=postgres://dev:dev@127.0.0.1:5432/golinks?sslmode=disable dbmate status
# Create a new migration
DATABASE_URL=postgres://dev:dev@127.0.0.1:5432/golinks?sslmode=disable dbmate new <migration_name>
# Rollback last migration
DATABASE_URL=postgres://dev:dev@127.0.0.1:5432/golinks?sslmode=disable dbmate down
# Reset database (down + up)
DATABASE_URL=postgres://dev:dev@127.0.0.1:5432/golinks?sslmode=disable dbmate down
DATABASE_URL=postgres://dev:dev@127.0.0.1:5432/golinks?sslmode=disable dbmate up
Migration files live in db/migrations/ and are managed by dbmate.
docker compose exec db psql -U dev -d golinks
Required after changing migrations or database structure. Must have the database running.
npx postgraphile \
--connection 'postgres://dev:dev@127.0.0.1:5432/golinks' \
--schema public \
--export-schema-graphql ./lib/type-defs.graphqls \
--subscriptions \
--dynamic-json \
--no-setof-functions-contain-nulls \
--no-ignore-rbac \
--no-ignore-indexes \
--show-error-stack=json \
--extended-errors hint,detail,errcode \
--append-plugins @graphile-contrib/pg-simplify-inflector \
--enable-query-batching \
--legacy-relations omit \
--no-server
Required after changing .graphql files or regenerating the schema.
yarn codegen
This reads .graphql files from lib/queries/ and lib/mutations/, combines with lib/type-defs.graphqls, and outputs TypeScript types + TypedDocumentNodes to lib/__generated__/graphql.ts.
dbmate new <name> -> edit -> dbmate upyarn codegen.graphql query/mutation files if new fields/types were addedyarn codegen again if queries/mutations changedlinks, link_usage_metricshas_permission() function checks jwt.claims.permissions for create:golinks, read:golinks, update:golinks, delete:golinkssearch_links() function for full-text searchis_private, created_by_email, allowed_emails fields