搜索
搜索结果
284 results for "database"

database-migrations
Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Kysely, Django, TypeORM, golang-migrate).
affaan-m
database-migrations
针对数据库 Schema 变动、数据迁移、回滚以及零停机部署的最佳实践,覆盖 PostgreSQL、MySQL 和常见 ORM/迁移工具(如 Prisma、Drizzle、Kysely、Django、TypeORM、golang-migrate)。
affaan-m
database-architect
Expert database architect specializing in data layer design from scratch, technology selection, schema modeling, and scalable database architectures.
sickn33
database-design
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
sickn33
database-lookup
Query documented public database APIs with explicit endpoints, filters, pagination, and provenance. Use when a scientific, regulatory, financial, or other database-backed fact must be retrieved reproducibly from a named source rather than inferred from general knowledge.
k-dense-ai
pr-workflow
General guidelines for Commits, formatting, CI, dependencies, security
tursodatabase
transaction-correctness
How WAL mechanics, checkpointing, concurrency rules, recovery work in tursodb
tursodatabase
differential-fuzzer
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
mvcc
Overview of Experimental MVCC feature - snapshot isolation, versioning, limitations
tursodatabase
testing
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
storage-format
SQLite file format, B-trees, pages, cells, overflow, freelist that is used in tursodb
tursodatabase
async-io-model
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
index-knowledge
Generate hierarchical AGENTS.md knowledge base for a codebase. Creates root + complexity-scored subdirectory documentation.
tursodatabase
debugging
How to debug tursodb using Bytecode comparison, logging, ThreadSanitizer, deterministic simulation, and corruption analysis tools
tursodatabase
database-optimizer
优化数据库查询并提升 PostgreSQL 和 MySQL 系统的性能。在调查慢查询、分析执行计划或优化数据库性能时使用。适用于索引设计、查询重写、配置调优、分区策略、锁争用解决等场景。
jeffallan
golang-database
Go数据库访问综合指南——参数化查询、结构体扫描、可空列、事务、隔离级别、SELECT FOR UPDATE、连接池、批量处理、上下文传播及迁移工具。适用于编写、审查或调试与PostgreSQL、MariaDB、MySQL或SQLite交互的Golang代码;用于数据库测试;或关于database/sql、sqlx、pgx的问题。不生成数据库模式或迁移SQL。
samber
database-schema-designer
为SQL和NoSQL数据库设计健壮、可扩展的数据库模式。提供规范化指南、索引策略、迁移模式、约束设计和性能优化。确保数据完整性、查询性能和可维护的数据模型。
softaworks
azure-sql-database
Expert knowledge for Azure SQL Database development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when choosing DTU/vCore tiers, configuring Hyperscale/HA, setting geo-replication/Data Sync, or automating CI/CD, and other Azure SQL Database related development tasks. Not for Azure SQL Managed Instance (use azure-sql-managed-instance), SQL Server on Azure Virtual Machines (use azure-sql-virtual-machines), Azure Cosmos DB (use azure-cosmos-db), Azure Data Factory (use azure-data-factory).
microsoftdocs
vitess
Vitess 最佳实践、查询优化和连接故障排查,适用于 PlanetScale Vitess 数据库。在处理 Vitess 数据库、分片、VSchema 配置、keyspace 管理或 MySQL 扩展问题时加载。
planetscale
neki
Overview and information about Neki, the sharded Postgres product by PlanetScale. Load when working with Neki-related tasks and the need to scale or shard postgres. Load when facing Postgres scaling or sharding issues.
planetscale
mysql
规划和审查 MySQL/InnoDB 的 schema、索引、查询调优、事务和运维。在创建或修改 MySQL 表、索引或查询时,诊断慢查询或锁行为时,规划迁移时,或排查复制和连接问题时使用。在使用 MySQL 数据库时加载。
planetscale
postgres
PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.
planetscale
database
This skill should be used when the user wants to add a database (Postgres, Redis, MySQL, MongoDB), says \"add postgres\", \"add redis\", \"add database\", \"connect to database\", or \"wire up the database\". For other templates (Ghost, Strapi, n8n, etc.), use the templates skill.
railwayapp
database-observability
Set up Grafana Cloud Database Observability for MySQL and PostgreSQL — enables `pg_stat_statements` / Performance Schema, creates a least-privilege monitoring user, configures the `database_observability.postgres` / `database_observability.mysql` Alloy components, ships query samples + visual explain plans + RED metrics + schema details to Grafana Cloud, and correlates slow queries with application traces via `db.statement` / `db.system` OTel attributes. Use when monitoring database performance, diagnosing slow queries, setting up DB observability for RDS / Aurora / Cloud SQL / Azure Database / self-managed instances, correlating DB metrics with APM, or alerting on query latency — even when the user says "my database is slow", "find the slow queries", or "monitor RDS" without saying "observability".
grafana