搜索
搜索结果
150 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-mdatabase-migrations
针对数据库 Schema 变动、数据迁移、回滚以及零停机部署的最佳实践，覆盖 PostgreSQL、MySQL 和常见 ORM/迁移工具（如 Prisma、Drizzle、Kysely、Django、TypeORM、golang-migrate）。
affaan-m
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
mysql
规划和审查 MySQL/InnoDB 的 schema、索引、查询调优、事务和运维。在创建或修改 MySQL 表、索引或查询时，诊断慢查询或锁行为时，规划迁移时，或排查复制和连接问题时使用。在使用 MySQL 数据库时加载。
planetscalepostgres
PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.
planetscale
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
neon-postgres-branches
Choose and create the right Neon branch type for testing and development. Use when users ask about Neon branching, migration testing with real data, isolated test environments, schema-only branch workflows for sensitive data, resetting a branch from its parent, branch expiration and CI/CD branch lifecycles, or branch creation via Neon CLI or Neon MCP. Triggers include "Neon branch", "test migrations safely", "branch production data", "schema-only branch", "reset branch", "branch per PR" and "sensitive data testing".
neondatabaseneon-postgres-egress-optimizer
Diagnose and fix excessive Postgres egress (network data transfer) in a codebase. Use when a user mentions high database bills, unexpected data transfer costs, network transfer charges, egress spikes, "why is my Neon bill so high", "database costs jumped", SELECT * optimization, query overfetching, reduce Neon costs, optimize database usage, or wants to reduce data sent from their database to their application. Also use when reviewing query patterns for cost efficiency, even if the user doesn't explicitly mention egress or data transfer.
neondatabaseclaimable-postgres
Provision instant temporary Postgres databases via Claimable Postgres by Neon (neon.new) with no login, signup, or credit card. Supports REST API, CLI, and SDK. Use when users ask for a quick Postgres environment, a throwaway DATABASE_URL for prototyping/tests, or "just give me a DB now". Triggers include: "quick postgres", "temporary postgres", "no signup database", "no credit card database", "instant DATABASE_URL", "npx neon-new", "neon.new", "neon.new API", "claimable postgres API".
neondatabaseneon
Neon平台概述，涵盖Postgres、Auth、Data API以及新服务：对象存储、计算函数和AI网关。当提到“Neon”或其任何单个能力（如“对象存储”或“S3”、“存储桶”、“无服务器函数”、“AI网关”、“调用LLM”、“postgres”、“数据库”或“后端”）时使用。
neondatabaseneon-postgres
使用 Neon Serverless Postgres 的指南和最佳实践。涵盖设置、连接方法、分支、自动扩缩容、自动暂停、只读副本、连接池、Neon Auth 以及 Neon CLI、MCP 服务器、REST API、TypeScript SDK 和 Python SDK。当用户询问“Neon 设置”、“连接到 Neon”、“Neon 项目”、“DATABASE_URL”、“无服务器 Postgres”、“Neon CLI”、“neonctl”、“Neon MCP”、“Neon Auth”、“@neondatabase/serverless”、“@neondatabase/neon-js”、“自动暂停”、“Neon 自动扩缩容”、“Neon 只读副本”或“Neon 连接池”时使用。
neondatabase
prisma-database-setup
配置 Prisma 与不同数据库提供商（PostgreSQL、MySQL、SQLite、MongoDB 等）的指南。适用于新建项目、切换数据库或排查连接问题。触发词包括“配置 postgres”、“连接 mysql”、“设置 mongodb”、“sqlite 设置”。
prismaagentic-os
Build persistent multi-agent operating systems on Claude Code. Covers kernel architecture, specialist agents, slash commands, file-based memory, scheduled automation, and state management without external databases. Use when building a persistent multi-agent system on Claude Code with its own memory, commands, and scheduling.
affaan-mflox-environments
Create reproducible, cross-platform (macOS/Linux) development environments with Flox, a declarative Nix-based environment manager. Use when setting up project toolchains for any language, installing system-level dependencies (compilers, databases, native libs like openssl/BLAS), pinning exact package versions for a team, running local services (PostgreSQL, Redis, Kafka), onboarding developers with one command, or solving 'works on my machine' problems — including agent/vibe-coding setups that need project-scoped tools without sudo. Also use when the user mentions .flox/, manifest.toml, flox activate, or FloxHub.
affaan-mtinystruct-patterns
Expert guidance for developing with the tinystruct Java framework. Use when working on the tinystruct codebase or any project built on tinystruct — including creating Application classes, @Action-mapped routes, unit tests, ActionRegistry, HTTP/CLI dual-mode handling, the built-in HTTP server, the event system, JSON with Builder/Builders, database persistence with AbstractData, POJO generation, Server-Sent Events (SSE), file uploads, and outbound HTTP networking.
affaan-mai-regression-testing
Regression testing strategies for AI-assisted development. Sandbox-mode API testing without database dependencies, automated bug-check workflows, and patterns to catch AI blind spots where the same model writes and reviews code.
affaan-mpostgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
affaan-mclickhouse-io
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
affaan-mbackend-patterns
Backend architecture patterns, API design, database optimization, and server-side best practices for Node.js, Express, and Next.js API routes.
affaan-magentic-os
在 Claude Code 上构建持久化多 Agent 操作系统。涵盖内核架构、专家 Agent、斜杠命令 (Slash commands)、基于文件的记忆、定时自动化以及无需外部数据库的状态管理。
affaan-mflox-environments
使用 Flox 打造可复现、跨平台（macOS/Linux）的开发环境。Flox 是一款基于 Nix 的声明式环境管理工具。适用于为任意语言搭建项目工具链、安装系统级依赖（编译器、数据库、openssl/BLAS 等底层原生库）、锁定团队统一的软件包版本、运行本地服务（PostgreSQL、Redis、Kafka）、一键完成新成员入职环境配置，或解决“在我电脑上明明能跑”的经典坑——也包括不需要 sudo 权限就能在项目作用域下安装所需工具的 AI Agent / vibe coding 场景。当用户提及 .flox/、manifest.toml、flox activate 或 FloxHub 时同样适用。
affaan-mtinystruct-patterns
基于 tinystruct Java 框架开发的专家级指导。适用于开发 tinystruct 本身或任何基于其构建的项目——涵盖 Application 类创建、@Action 路由映射、单元测试、ActionRegistry、HTTP/CLI 双模式处理、内置 HTTP 服务器、事件系统、基于 Builder/Builders 的 JSON 处理、基于 AbstractData 的数据库持久化、POJO 自动生成、服务端发送事件（SSE）、文件上传以及出站 HTTP 网络请求等场景。
affaan-m