skills.rest
kourou25
kourou25COMMUNITY
Explore all skills by this author →
GitHub

虚谷数据库系统函数

Provides XuguDB system functions reference with cross-database migration mappings.

4|4|Updated Apr 7, 2026
Search Tags:#migration#json#sql#aggregate#datetime#xugudb#system-functions
One-click install
npx skills add https://github.com/kourou25/xugudb-dev-skills --skill -kourou25
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: 虚谷数据库系统函数
Source: https://github.com/kourou25/xugudb-dev-skills/tree/main/skills/xugudb-functions
Command: npx skills add https://github.com/kourou25/xugudb-dev-skills --skill -kourou25

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

本技能提供面向开发者和数据库管理员的完整函数参考，解决在使用或迁移到虚谷数据库（XuguDB）时函数名称、语义和用法不明确的问题，避免因函数差异导致的查询错误或迁移失败。

Core Features & Use Cases

  • 全面分类参考：按字符串、数学、日期时间、聚合、分析、JSON、XML、数组、几何等 21 类函数组织，共 472 个内置函数条目，便于快速查找。
  • 示例与语法：为常用函数提供 SQL 使用示例和注意事项，帮助编写正确查询和调优。
  • 跨库迁移指南：提供与 Oracle、MySQL、PostgreSQL 的函数对照表和迁移提示，适用于代码迁移、兼容性检查和数据库重构场景。
  • 实战场景：适合编写复杂报表、实现 JSON 处理、处理时间序列运算、以及在迁移项目中定位替换函数。

Quick Start

查询 XuguDB 中 JSON_EXTRACT、ADD_MONTHS 和 LISTAGG 的用法并给出对应的 Oracle/MySQL/PostgreSQL 迁移建议。

Frequently Asked Questions about 虚谷数据库系统函数

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I migrate SQL functions from Oracle or MySQL to XuguDB?▼

Migrate SQL functions to XuguDB using cross-database name and behavior mappings. The reference provides compatibility tables and migration notes covering string, datetime, JSON, and aggregate functions for translating queries between Oracle, MySQL, and PostgreSQL.

What XuguDB system functions are available for processing JSON data?▼

XuguDB system functions for JSON data processing include categorized JSON functions with SQL usage examples. You can locate specific JSON operations within the 472 built-in function entries to implement JSON processing in complex queries.

Does XuguDB support analytic functions like LISTAGG for complex reporting?▼

XuguDB supports analytic functions like LISTAGG for complex reporting. The reference includes categorized lists of analytic functions with syntax examples and cross-database compatibility notes for migration engineers.

How do I find the correct syntax conversion for datetime functions in XuguDB?▼

Find correct syntax conversion for XuguDB datetime functions by checking the categorized datetime function lists. The reference provides SQL usage examples, syntax details, and cross-database migration suggestions for functions like ADD_MONTHS.

What are the limitations when porting PostgreSQL aggregate functions to XuguDB?▼

Limitations when porting PostgreSQL aggregate functions to XuguDB are detailed in the migration notes and compatibility tables. The reference highlights behavior mappings and specific function differences to prevent query errors during database migration.

Related Skills

Explore More Software Engineering Skills→
kourou25kourou25
4

虚谷数据库 SQL 语法参考

Reference XuguDB SQL syntax for DDL, DML, queries, and operators.

Community
Intermediate
MayaDispelerMayaDispeler
3

sql-standards

Reference SQL style, correctness, performance, and anti-pattern avoidance standards.

Community
Advanced
ccfosccfos
13.2k

sql-generator

Translate natural language descriptions into executable SQL queries for database analysis.

Official
Intermediate
christopherlouetchristopherlouet
5

ops-database

Design database schemas, indexes, and migrations with SQL and TypeScript scripts.

Community
Advanced