数据库

SQL、Schema 设计、迁移和数据库操作

217 个 Skills 可用

Skills 列表

create-spring-boot-java-project

create-spring-boot-java-project

36Kdatabase

创建Spring Boot Java项目骨架

github avatargithub
获取
ef-core

ef-core

36Kdatabase

获取 Entity Framework Core 的最佳实践

github avatargithub
获取
snowflake-semanticview

snowflake-semanticview

36Kdatabase

使用 Snowflake CLI (snow) 创建、修改和验证 Snowflake 语义视图。当需要构建或排查语义视图/语义层定义(使用 CREATE/ALTER SEMANTIC VIEW)、通过 CLI 验证语义视图 DDL 或指导 Snowflake CLI 安装和连接设置时使用。

github avatargithub
获取
postgresql-code-review

postgresql-code-review

36Kdatabase

PostgreSQL 代码审查助手,专注于 PostgreSQL 最佳实践、反模式和独特质量标准。涵盖 JSONB 操作、数组使用、自定义类型、模式设计、函数优化以及行级安全(RLS)等 PostgreSQL 专属安全特性。

github avatargithub
获取
sql-code-review

sql-code-review

36Kdatabase

通用SQL代码审查助手,对MySQL、PostgreSQL、SQL Server、Oracle等所有SQL数据库进行全面安全、可维护性和代码质量分析。专注于SQL注入防护、访问控制、代码标准和反模式检测。与SQL优化提示互补,实现完整的开发覆盖。

github avatargithub
获取
sql-optimization

sql-optimization

36Kdatabase

通用SQL性能优化助手,提供全面的查询调优、索引策略和数据库性能分析,支持所有SQL数据库(MySQL、PostgreSQL、SQL Server、Oracle)。提供执行计划分析、分页优化、批量操作和性能监控指导。

github avatargithub
获取
postgresql-optimization

postgresql-optimization

36Kdatabase

PostgreSQL专用开发助手,专注于PostgreSQL独特功能、高级数据类型和PostgreSQL专属能力。涵盖JSONB操作、数组类型、自定义类型、范围/几何类型、全文搜索、窗口函数和PostgreSQL扩展生态系统。

github avatargithub
获取
pr-workflow

pr-workflow

24Kdatabase

General guidelines for Commits, formatting, CI, dependencies, security

tursodatabase avatartursodatabase
获取
transaction-correctness

transaction-correctness

24Kdatabase

How WAL mechanics, checkpointing, concurrency rules, recovery work in tursodb

tursodatabase avatartursodatabase
获取
differential-fuzzer

differential-fuzzer

24Kdatabase

Information about the differential fuzzer tool, how to run it and use it catch bugs in Turso. Always load this skill when running this tool

tursodatabase avatartursodatabase
获取
mvcc

mvcc

24Ktesting-qa

Overview of Experimental MVCC feature - snapshot isolation, versioning, limitations

tursodatabase avatartursodatabase
获取
testing

testing

24Kdatabase

How to write tests, when to use each type of test, and how to run them. Contains information about conversion of `.test` to `.sqltest`, and how to write `.sqltest` and rust tests

tursodatabase avatartursodatabase
获取
storage-format

storage-format

24Kdatabase

SQLite file format, B-trees, pages, cells, overflow, freelist that is used in tursodb

tursodatabase avatartursodatabase
获取
async-io-model

async-io-model

24Kdatabase

Explanations of common asynchronous patterns used in tursodb. Involves IOResult, state machines, re-entrancy pitfalls, CompletionGroup. Always use these patterns in `core` when doing anything IO

tursodatabase avatartursodatabase
获取
index-knowledge

index-knowledge

24Kagent-workflows

Generate hierarchical AGENTS.md knowledge base for a codebase. Creates root + complexity-scored subdirectory documentation.

tursodatabase avatartursodatabase
获取
debugging

debugging

24Ktesting-qa

How to debug tursodb using Bytecode comparison, logging, ThreadSanitizer, deterministic simulation, and corruption analysis tools

tursodatabase avatartursodatabase
获取
cloud-monitoring-list-time-series-request

cloud-monitoring-list-time-series-request

19Kdatabase

Generates valid Cloud Monitoring ListTimeSeries requests and aggregation specifications from metric descriptors and resource parameters. Use when asked to create, generate, format, or build ListTimeSeries requests, JSON payloads, filter expressions, or aligner/reducer aggregations for Cloud Monitoring metrics and charts. Don't use for metric discovery or metric selection.

google avatargoogle
获取
spanner-basics

spanner-basics

19Kdatabase

Assists in provisioning instances and databases, designing performant schemas, and querying data in Spanner. Use when designing primary keys, writing SQL queries or client library code, or diagnosing performance issues.

google avatargoogle
获取
wren

wren

18Kdatabase

Wren CLI for AI agents — a semantic SQL layer over 22+ databases (Postgres, MySQL, BigQuery, Snowflake, Spark, …). The actual workflow guides live inside the `wren` CLI itself; this is just a discovery stub. Use whenever the user asks a data question (how many, show me, top N, compare, trend, breakdown, metric, revenue, customers, orders), wants to install / set up Wren Engine, connect a new database, connect SaaS data via dlt (HubSpot, Stripe, Salesforce, GitHub, Slack), generate or regenerate an MDL project from a database schema, enrich a project with business context (enum meanings, units, cubes like ARR / DAU / churn), or turn a project's context layer into a shareable GenBI web app / dashboard and deploy it to Vercel or Cloudflare. Triggers: 'install wren', 'set up wren engine', 'connect database to wren', 'connect SaaS to wren', 'load hubspot / stripe / salesforce data', 'generate mdl', 'scaffold wren project', 'enrich wren context', 'augment my project', 'add cubes', 'build a dashboard', 'make a shareable analytics app', 'deploy my context layer as a web app', 'genbi app', 'wren onboarding', 'wren usage', 'wren generate mdl', 'wren dlt connector', 'wren enrich context', 'wren genbi'.

canner avatarcanner
获取
bigquery-bigframes

bigquery-bigframes

16Kdatabase

Generates Python code using BigQuery DataFrames (BigFrames), the pandas/scikit-learn-style API over BigQuery. Use when writing BigFrames code or doing pandas-style dataframe/ML work against BigQuery (e.g. in a notebook). Don't use for SQL-first workflows or the google-cloud-bigquery client library — use bigquery-basics.

google avatargoogle
获取
cloud-sql-basics

cloud-sql-basics

15Kdatabase

此文件用于生成或解释 Cloud SQL 资源。当用户要求为 MySQL、PostgreSQL 或 SQL Server 创建 Cloud SQL 实例或数据库时,请使用此文件。 Cloud SQL 将第三方 MySQL、PostgreSQL 和 SQL Server 实例作为 Cloud SQL 中的资源进行管理。例如,当 Cloud SQL 创建一个开源 MySQL 实例时,生成的资源是 Google Cloud 管理的 Cloud SQL for MySQL 实例。 Cloud SQL 负责处理关系型数据库工作负载的备份、高可用性和安全连接。

google avatargoogle
获取
fullstack-dev

fullstack-dev

13Kdatabase

全栈后端架构与前后端集成指南。 触发场景:构建全栈应用、配合前端开发 REST API、脚手架搭建后端服务、开发 Todo 应用、开发 CRUD 增删改查应用、开发实时应用、开发聊天应用、Express + React、Next.js API、Node.js 后端、Python 后端、Go 后端、设计服务层、实现错误处理、管理配置/鉴权、配置 API 客户端、实现身份验证流程、处理文件上传、添加实时功能(SSE/WebSocket)、生产环境加固。 不触发场景:纯前端 UI 工作、纯 CSS/样式调节、仅数据库 Schema 设计。

minimax-ai avatarminimax-ai
获取
seo-drift

seo-drift

12Kdatabase

SEO漂移监控:捕获SEO关键元素的基线,检测变化,并随时间追踪回归。SEO的Git:对页面SEO进行基线、差异和变更追踪。当用户提到“SEO漂移”、“基线”、“追踪变化”、“是否出问题”、“SEO回归”、“比较SEO”、“前后对比”、“监控SEO变化”或“部署检查”时使用。

agricidaniel avataragricidaniel
获取
rails-expert

rails-expert

11Kdatabase

Rails 7+ 专家,精通通过 includes/eager_load 优化 Active Record 查询、使用 Turbo Frames 和 Turbo Streams 实现页面局部刷新、配置 Action Cable 处理 WebSocket 实时连接、搭建 Sidekiq worker 处理后台异步任务,以及编写全方位的 RSpec 测试套件。适用于构建基于 Hotwire、包含实时功能或后台任务处理的 Rails 7+ Web 应用程序。涉及 Active Record 性能优化、Turbo Frames/Streams、Action Cable、Sidekiq、RSpec Rails 等场景时调用。

jeffallan avatarjeffallan
获取