数据库

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

307 個 Skills 可用

Skills 列表

analyzing-browser-forensics-with-hindsight

analyzing-browser-forensics-with-hindsight

34Kdatabase

Parse Chromium-based browser databases with Hindsight to extract and correlate browsing history, downloads, cookies, cached content, autofill data, saved passwords, and extensions from Chrome, Edge, Brave, Opera, and Vivaldi into a unified timeline (XLSX, JSON, or SQLite output). Use during incident response, insider-threat investigations, or criminal cases when you need to reconstruct a user's web activity from a browser profile.

mukul975 avatarmukul975
獲取
analyzing-certificate-transparency-for-phishing

analyzing-certificate-transparency-for-phishing

34Kdatabase

Monitor Certificate Transparency logs using crt.sh and Certstream to

mukul975 avatarmukul975
獲取
commit-helper

commit-helper

33Ktesting-qa

Help create git commits and PRs with properly formatted messages and release notes following CockroachDB conventions. Use when committing changes or creating pull requests.

cockroachdb avatarcockroachdb
獲取
chief-data-officer-advisor

chief-data-officer-advisor

27Kdatabase

Chief Data Officer advisory for startups: AI training data rights and consent provenance, data product strategy (warehouse vs lakehouse vs mesh, build-vs-buy), B2B customer-data-as-asset valuation and M&A readiness, data team org evolution. Use when deciding whether to train models on customer data, choosing data architecture, valuing data for fundraising or M&A, sequencing data hires, or when user mentions CDO, chief data officer, data strategy, data mesh, lakehouse, training data, data product, data monetization, or customer data asset. NOT a tactical data engineering skill — strategic decisions only.

alirezarezvani avataralirezarezvani
獲取
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
獲取
dbt-sf-to-bq-translator

dbt-sf-to-bq-translator

21Kdatabase

Translates Snowflake dbt SQL models to Standardized BigQuery SQL. Handles SQL compilation, Jinja macro placeholder masking, BigQuery Translation Service migration workflows, AST-based config transformations, explicit type casting, JSON extraction standardization, and deduplication. Use when migrating Snowflake dbt pipelines or models to Google Cloud BigQuery. Don't use for generic BigQuery queries or non-Snowflake SQL migrations.

google avatargoogle
獲取
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

This file generates or explains Cloud SQL resources. Use this file when the user asks to create a Cloud SQL instance or database for MySQL, PostgreSQL, or SQL Server. Cloud SQL manages third-party MySQL, PostgreSQL, and SQL Server instances as resources in Cloud SQL. For example, when Cloud SQL creates an open-source MySQL instance, the resulting resource is a Cloud SQL for MySQL instance that Google Cloud manages. Cloud SQL handles backups, high availability, and secure connectivity for relational database workloads.

google avatargoogle
獲取
fullstack-dev

fullstack-dev

13Kdatabase

Full-stack backend architecture and frontend-backend integration guide. TRIGGER when: building a full-stack app, creating REST API with frontend, scaffolding backend service, building todo app, building CRUD app, building real-time app, building chat app, Express + React, Next.js API, Node.js backend, Python backend, Go backend, designing service layers, implementing error handling, managing config/auth, setting up API clients, implementing auth flows, handling file uploads, adding real-time features (SSE/WebSocket), hardening for production. DO NOT TRIGGER when: pure frontend UI work, pure CSS/styling, database schema only.

minimax-ai avatarminimax-ai
獲取
seo-drift

seo-drift

12Kdatabase

SEO drift monitoring: capture baselines of SEO-critical elements, detect changes, and track regressions over time. Git for SEO: baseline, diff, and track changes to your on-page SEO. Use when user says "SEO drift", "baseline", "track changes", "did anything break", "SEO regression", "compare SEO", "before and after", "monitor SEO changes", or "deployment check".

agricidaniel avataragricidaniel
獲取
rails-expert

rails-expert

11Kdatabase

Rails 7+ specialist that optimizes Active Record queries with includes/eager_load, implements Turbo Frames and Turbo Streams for partial page updates, configures Action Cable for WebSocket connections, sets up Sidekiq workers for background job processing, and writes comprehensive RSpec test suites. Use when building Rails 7+ web applications with Hotwire, real-time features, or background job processing. Invoke for Active Record optimization, Turbo Frames/Streams, Action Cable, Sidekiq, RSpec Rails.

jeffallan avatarjeffallan
獲取
database-optimizer

database-optimizer

11Kdatabase

Optimizes database queries and improves performance across PostgreSQL and MySQL systems. Use when investigating slow queries, analyzing execution plans, or optimizing database performance. Invoke for index design, query rewrites, configuration tuning, partitioning strategies, lock contention resolution.

jeffallan avatarjeffallan
獲取
sql-pro

sql-pro

11Kdatabase

Optimizes SQL queries, designs database schemas, and troubleshoots performance issues. Use when a user asks why their query is slow, needs help writing complex joins or aggregations, mentions database performance issues, or wants to design or migrate a schema. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis, covering index creation, recursive queries, EXPLAIN/ANALYZE interpretation, before/after query benchmarking, or migrating queries between database dialects (PostgreSQL, MySQL, SQL Server, Oracle).

jeffallan avatarjeffallan
獲取