跳到主内容
智客 ZICQ

技能库 智客分类:Agent 工作流 prisma-postgres

Prisma Postgres

Prisma Postgres设置和操作指导横跨Console,创建-db CLI,管理API,以及管理API SDK. 创建 Prisma Postgres 数据库时使用,在 Prisma Console 工作,提供creat-db/creat-pg/creat-postgres,或将程序提供与服务符或OAuth整合.

301503 安装量

官方网址:skills.sh

技能介绍

先看中文介绍;官方 description 原文单独保留,不改写 SKILL.md。

做什么

Prisma Postgres 整个控制台的设置和操作指导,创建-db CLI,管理 API,和管理 API SDK

何时用

创建 Prisma Postgres数据库,在Prisma Console工作,提供创建-db/create-pg/create-postgres,或将方案提供与服务符或OAuth整合

代理如何加载

按 Agent Skills 渐进披露:启动时只加载 name 与 description(约 100 token);任务匹配后才读入整份 SKILL.md 正文;scripts/、references/、assets/ 仅在需要时再读。 本文件正文结构:Prisma Postgres、When to Apply、Rule Categories by Priority、Quick Reference、Core Workflows、1. Console-first workflow。 其中含规范建议的小节:分步指令。

文件分析

文件分析:除 SKILL.md 外,正文引用了 references/console-and-connections.md、references/create-db-cli.md、references/management-api.md、references/management-api-sdk.md,属于带资源的技能包,这些文件按需再读。

官方 description(原文)

Prisma Postgres setup and operations guidance across Console, create-db CLI, Management API, and Management API SDK. Use when creating Prisma Postgres databases, working in Prisma Console, provisioning with create-db/create-pg/create-postgres, or integrating programmatic provisioning with service tokens or OAuth.

Prisma PostgresWhen to ApplyRule Categories by PriorityQuick ReferenceCore Workflows1. Console-first workflow2. Quick provisioning with create-db2b. Persistent databases with the Platform CLI3. Link an existing local project4. Programmatic provisioning with Management API5. Type-safe integration with Management API SDKRule Files

· 许可:MIT

来源分类:skills.sh agent-skill

SKILL.md 与 Agent 调用

官方规范 ↗
name
prisma-postgres
description
Prisma Postgres setup and operations guidance across Console, create-db CLI, Management API, and Management API SDK. Use when creating Prisma Postgres databases, working in Prisma Console, provisioning with create-db/create-pg/create-postgres, or integrating programmatic provisioning with service tokens or OAuth.
许可
MIT
  1. 发现技能客户端向 Agent 提供名称与描述目录。
  2. 匹配与调用用户指定或任务匹配后,载入 SKILL.md 指令。
  3. 按需加载按步骤读取参考文档、使用脚本与素材。
指令中引用的文件 · 4
  • references/console-and-connections.md
  • references/create-db-cli.md
  • references/management-api.md
  • references/management-api-sdk.md

以下路径提取自原文;文件是否齐全请以来源仓库中的完整目录为准。

具体调用语法与可用工具以目标 Agent 客户端为准。 查看调用机制说明 ↗

安装这个技能

Skills CLI ↗

先选择目标 Agent 和安装范围,保留技能包的附属文件,安装后检查客户端能否发现该技能。

该技能引用了附属文件,请从来源获取完整目录;仅复制 SKILL.md 可能缺少依赖。

交给 Agent 安装

复制安装指令给支持 Agent Skills 的代理,确认其中的目标目录与客户端匹配。

把 Agent Skill「prisma-postgres」安装到我的项目:SKILL.md 原文与官方 description 见 https://zicq.com/zh/skills/skl-c795fd0c7fefe92c-Prisma-%E9%82%AE%E6%94%BF.html
请存为 .cursor/skills/prisma-postgres/SKILL.md 或 .claude/skills/prisma-postgres/SKILL.md,frontmatter 的 name 与 description 保持原样,不要改写。
该技能还带 scripts/、references/、assets/ 等文件,请从 https://github.com/prisma/skills 取完整目录,不要只建一个 SKILL.md。

GitHub 完整包 ↗

终端安装 · Skills CLI

需要 Node.js 与 npx。先查看仓库技能列表,确认实际名称。

npx skills add 'https://github.com/prisma/skills' --list

npx skills add 'https://github.com/prisma/skills' --skill 'prisma-postgres'

CLI 会交互选择目标 Agent,默认安装到项目;用户级安装使用 -g。先通过查看命令核对仓库内容,再用 npx skills list 检查已安装技能。

阅读排版
--- name: prisma-postgres description: Prisma Postgres setup and operations guidance across Console, create-db CLI, Management API, and Management API SDK. Use when creating Prisma Postgres databases, working in Prisma Console, provisioning with create-db/create-pg/create-postgres, or integrating programmatic provisioning with service tokens or OAuth. license: MIT metadata: author: prisma version: "7.9.1" --- # Prisma Postgres Guidance for creating, managing, and integrating Prisma Postgres across interactive and programmatic workflows. ## When to Apply Reference this skill when: - Setting up Prisma Postgres from Prisma Console - Provisioning instant temporary databases with `create-db` - Linking an existing local project with `prisma postgres link` - Managing Prisma Postgres resources via Management API - Using `@prisma/management-api-sdk` in TypeScript/JavaScript - Handling claim URLs, connection strings, regions, and auth flows ## Rule Categories by Priority | Priority | Category | Impact | Prefix | |----------|----------|--------|--------| | 1 | CLI Provisioning | CRITICAL | `create-db-cli` | | 2 | Management API | CRITICAL | `management-api` | | 3 | Management API SDK | HIGH | `management-api-sdk` | | 4 | Console and Connections | HIGH | `console-and-connections` | ## Quick Reference - `create-db-cli` - instant databases and current CLI flags (`--ttl`, `--copy`, `--quiet`, `--open`) - `management-api` - service token and OAuth API workflows - `management-api-sdk` - typed SDK usage with token storage - `console-and-connections` - Console operations, `prisma postgres link`, direct TCP connections, and serverless-driver choices ## Core Workflows ### 1. Console-first workflow Use Prisma Console for manual setup and operations: - Open `https://console.prisma.io` - Create/select workspace and project - Use Studio in the project sidebar to view/edit data - Retrieve direct connection details from the project UI ### 2. Quick provisioning with create-db Use `create-db` when you need a database immediately: ```bash npx create-db@latest ``` Aliases: ```bash npx create-pg@latest npx create-postgres@latest ``` For app integrations, you can also use the programmatic API (`create()` / `regions()`) from the `create-db` npm package. Temporary databases auto-delete after ~24 hours unless claimed. ### 2b. Persistent databases with the Platform CLI For databases that belong to a Project (not throwaway `create-db` databases), use `@prisma/cli`: ```bash npx -y @prisma/cli@latest database create --help npx -y @prisma/cli@latest database list --json npx -y @prisma/cli@latest database connection create db_123 npx -y @prisma/cli@latest database usage db_123 npx -y @prisma/cli@latest database backup list db_123 ``` `database create` and `database connection create` print a one-time connection URL; store it immediately. Destructive commands (`remove`, `restore`) require exact `--confirm `. For automation, prefer `--json --no-interactive`, resolve ids before mutations, and verify the installed command's help because this CLI is beta. ### 3. Link an existing local project Use `prisma postgres link` when the database already exists and you want to wire a local project to it: ```bash prisma postgres link ``` For CI or other non-interactive environments: ```bash prisma postgres link --api-key "" --database "db_..." ``` This flow updates your local `.env` with `DATABASE_URL`, then you can run `prisma generate` and `prisma migrate dev`. ### 4. Programmatic provisioning with Management API Use API endpoints on: ```text https://api.prisma.io/v1 ``` Explore the schema and endpoints using: - OpenAPI docs: `https://api.prisma.io/v1/doc` - Swagger Editor: `https://api.prisma.io/v1/swagger-editor` Auth options: - Service token (workspace server-to-server) - OAuth 2.0 (act on behalf of users) ### 5. Type-safe integration with Management API SDK Install and use: ```bash npm install @prisma/management-api-sdk ``` Use `createManagementApiClient` for existing tokens, or `createManagementApiSdk` for OAuth + token refresh. The SDK exposes typed workspace service-token list, create, and revoke routes. A newly created token value is returned exactly once. Let the installed SDK types or OpenAPI document settle exact beta endpoint shapes. ## Rule Files Detailed guidance lives in: ``` references/console-and-connections.md references/create-db-cli.md references/management-api.md references/management-api-sdk.md ``` ## How to Use Start with `references/create-db-cli.md` for fast setup, then switch to `references/management-api.md` or `references/management-api-sdk.md` when you need programmatic provisioning.

相关技能

Agent 工作流

Skill Creator

创造有效技能指南。 当用户想创造出新的技能(或更新现有的技能),以专业知识,工作流程,或工具集成来扩展克洛德的能力时,应该使用这种技能.

Agent 工作流

Clawdhub

使用ClawdHub CLI搜索,安装,更新并发布从taladhub.com的代理技能. 需要获取苍蝇上的新技能时使用,将安装的技能同步到最新版本或特定版本,或者发布 npm-instainddhub CLI 的新/更新的技能文件夹.

Agent 工作流

Agent Team Orchestration

管弦乐团多代理团队,任务设定周期,交接协议,审查工作流程. 使用时间: (1)建立2+特派员队伍,具有不同专业,(2)确定任务路线和生命周期(收录框_ spec_建设_审查_完成),(3)在特派员之间制定交接协议,(4)建立审查和质量关口,(5)管理特派员之间的交流和文物共享.

Agent 工作流

Superpowers

Spec-first,TDD,子代理驱动的软件开发工作流程. 当:(1)构建任何新功能或应用——触发脑暴_计划_子代理执行回路,(2)调试出一个bug或测试失败——触发系统性的根起过程,(3)用户说"让我们构建","帮助我计划","我想添加X",或"这个被打破",(4)完成一个功…