“MySQL”

PostgreSQL and MySQL query execution plan decoding

Database operations — PostgreSQL, MySQL, MongoDB, Redis queries

Implement a middleware/interceptor for Spring Boot + MySQL (or any JPA/Hibernate stack) that counts the number of SQL queries executed per HTTP request and…

Optimizes SQL queries, designs database schemas, and troubleshoots performance issues.

Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs…

Query external databases (PostgreSQL, MySQL, SQL Server, Snowflake, BigQuery) directly from Databricks using Lakehouse Federation.

Query optimization, indexing strategies, and database performance tuning for PostgreSQL and MySQL

Java 八股文复习技能。从所有题库篇章中随机抽选题目进行复习，支持每日混合复习、按篇章复习、薄弱题强化。题库覆盖：Java 基础、集合框架、并发编程、JVM、Redis、MySQL、Spring 共 7 大板块 454 题。使用场景：(1) 开始每日复习 (2) 随机抽选题目 (3) 专项突破 (4) 薄弱题强化。

Setup backend project with Flyway SQL migrations, tini init system, and MySQL integration testing.

Database RCE paths — UDF, xp_cmdshell, COPY TO PROGRAM, Redis key write.

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…

Vitess best practices, query optimization, and connection troubleshooting for PlanetScale Vitess databases.

Use when deploying a database to Zeabur.

Set up Prisma ORM in an application, connect its database, or troubleshoot the connection of an existing Prisma 6, 7, or 8 app.

MariaDB-specific SQL dialect knowledge — correctness pitfalls (NULL/GROUP BY/collation semantics), performance (optimizer, indexes, EXPLAIN reading)…

Use when the user has tabular data (pandas DataFrame, parquet, csv, Arrow, json) and wants to filter, group, aggregate, join, or speed up slow pandas.

Execute read-only SQL queries against multiple Microsoft SQL Server databases.

基于 EdgeOne Pages 的全栈网站生成方案。用户说一句话（如「帮我建一个电商站」「做一个AI客服站」「做个管理后台」），AI 自动组合 Auth、Cart、Payment、AI Chat、Admin 五大模块，生成完整 Next.js 前后端代码并部署到 EdgeOne Pages 全球…

Helps users configure mirrord.json for database branching, enabling isolated database copies for safe development and testing.

PostgreSQL schema design, query tuning, and comprehensive SQLSTATE error debugging via Laravel 11 migrations and Eloquent.

Generates production-ready docker-compose.yml and Dockerfile(s) for a project by scanning its manifest files (package.json, pyproject.toml, Gemfile, go.mod…

Investigate an existing database from DDL, text schema exports, or design documents, without connecting to a database.

Review or write a database schema migration with production safety as the bar, checking locks, table rewrites, backfills, expand-contract deploy order, index…

Creates a complete Amazon Aurora database cluster with instances, handling cluster creation, instance provisioning, and Secrets Manager password management in…