PolarDB-X AI 函数使用指南。覆盖模型注册管理、AI 推理函数(AI_PROMPT/AI_EMBEDDING/AI_SIMILARITY/AI_CLASSIFY/AI_EXTRACT/AI_SUMMARIZE/AI_RANK/AI_TEXT2SQL/AI_PARSE_DOCUMENT/AI_VL_EMBEDDING)的完整用法与最佳实践。 Use when the user asks how to use AI functions in SQL, how to register/manage AI…
polardb/polardbx-sql
SkillsMP 已收集 polardb/polardbx-sql 中的 9 个 Skill。打开任一 Skill 可查看来源和详情。
- 最近记录的来源活动
- SkillsMP 收录数据更新
- 已收集 skills
- 9
- GitHub 星标
- 1,686
- GitHub Forks
- 337
用 AI 助手安装
复制这段 Prompt,发给你正在使用的 AI 助手。
Follow https://skillsmp.com/skill-install/prompt.md to install Agent Skills from https://github.com/polardb/polardbx-sql.这个仓库中的 skills
已展示 9 / 9 个已收集 Skill。
Online DDL safety assessment and lock-free execution for PolarDB-X 2.0 Enterprise Edition. Determines if DDL locks the table via EXPLAIN ONLINE_DDL, rewrites with ALGORITHM=OMC for lock-free execution, checks long transactions before DDL, and guides safe DDL…
原文语言:英语
PolarDB-X 运维诊断视图完整参考。覆盖事务/锁、慢SQL、DDL、执行计划、分区拓扑、存储资源、列存、内存等八大场景的 information_schema 视图用法与示例 SQL。 Use when diagnosing performance issues, checking cluster health, analyzing slow queries, monitoring DDL progress, investigating locks/transactions, or inspecting…
Efficient pagination and large table traversal for PolarDB-X 2.0 Enterprise Edition. Recommends Keyset pagination (cursor pagination) over LIMIT M,N for deep pagination scenarios, provides per-shard traversal for extreme cases, includes index requirements and…
原文语言:英语
Design partition schemes, select partition keys, create GSI, and write CREATE TABLE SQL for PolarDB-X 2.0 Enterprise Edition AUTO mode databases. Use when designing partition schemes, selecting partition keys, converting single tables to partitioned tables,…
原文语言:英语
Analyze PolarDB-X execution plans or determine semantic equivalence between SQL and execution plans. Covers EXPLAIN / EXPLAIN COST / EXPLAIN ANALYZE operator interpretation, cost estimation analysis, runtime statistics bottleneck identification, SQL-to-plan…
原文语言:英语
MySQL to PolarDB-X compatibility checks, Sequence usage, and distributed transactions for PolarDB-X 2.0 Enterprise Edition AUTO mode. Use when migrating MySQL SQL to PolarDB-X, checking compatibility differences, using Sequence, or understanding distributed…
原文语言:英语
Generate correct TTL 2.0 definitions and archive table statements for PolarDB-X 2.0 Enterprise Edition AUTO mode. Analyzes table schemas to recommend the optimal archiving strategy (row-based or partition-based) and produces production-ready SQL. Also covers…
原文语言:英语
PolarDB-X 向量搜索使用指南。覆盖 VECTOR 数据类型、向量函数(VEC_FROMTEXT/VEC_TOTEXT/VEC_DISTANCE/VEC_DISTANCE_COSINE/VEC_DISTANCE_EUCLIDEAN/VECTOR_DIM)、VECTOR INDEX 创建与管理、ANN 近似最近邻搜索的完整用法与最佳实践。 Use when the user asks how to use vector search features, VECTOR data type, vector…