> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/tools/community/mariadb-ai-plugins/skills-reference/built-in-function-skills.md).

# Built-in Function Skills

Reference for the MariaDB AI Plugins skills that cover MariaDB built-in function families.

Each of these skills covers a group of built-in functions, such as the string, date and time, or JSON functions.

| Skill                            | Plugins      | What it covers                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| -------------------------------- | ------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `mariadb-json-functions`         | `dev`, `sql` | MariaDB JSON functions — complete catalog of JSON\_\*, JSON\_ARRAY/OBJECT constructors and aggregates (JSON\_ARRAYAGG, JSON\_OBJECTAGG), extraction (JSON\_EXTRACT, JSON\_VALUE, JSON\_QUERY, JSON\_TABLE, ->, ->>), modification (JSON\_SET, JSON\_INSERT, JSON\_REPLACE, JSON\_REMOVE, JSON\_ARRAY\_APPEND, JSON\_ARRAY\_INSERT), merge variants (JSON\_MERGE, JSON\_MERGE\_PATCH, JSON\_MERGE\_PRESERVE), validation (JSON\_VALID, JSON\_SCHEMA\_VALID, IS JSON), introspection (JSON\_TYPE, JSON\_DEPTH, JSON\_LENGTH, JSON\_KEYS, JSON\_CONTAINS, JSON\_EQUALS), formatting (JSON\_DETAILED/PRETTY, JSON\_COMPACT, JSON\_LOOSE, JSON\_QUOTE, JSON\_UNQUOTE), and JSON\_TABLE for relational projection. |
| `mariadb-string-functions`       | `dev`, `sql` | MariaDB string functions — extraction (SUBSTRING/SUBSTR, LEFT, RIGHT, MID, SUBSTRING\_INDEX); length in bytes (LENGTH/OCTET\_LENGTH/LENGTHB) vs characters (CHAR\_LENGTH/CHARACTER\_LENGTH); search (LOCATE, INSTR, POSITION, FIND\_IN\_SET, FIELD); concatenation (CONCAT, CONCAT\_WS); modification (REPLACE, INSERT, REVERSE, REPEAT, SPACE, LPAD/RPAD, TRIM/LTRIM/RTRIM); case (LOWER/UPPER); PCRE2 regular expressions (REGEXP/RLIKE, REGEXP\_REPLACE, REGEXP\_INSTR, REGEXP\_SUBSTR); formatting (FORMAT, SFORMAT); encoding (HEX/UNHEX, TO\_BASE64/FROM\_BASE64, ASCII, CHAR, ORD); plus the LIKE, REGEXP, SOUNDS LIKE, and BINARY operators.                                                         |
| `mariadb-date-time-functions`    | `dev`, `sql` | MariaDB date and time functions — current time (NOW, CURRENT\_TIMESTAMP, SYSDATE, CURDATE, CURTIME, UTC\_TIMESTAMP/UTC\_DATE/UTC\_TIME), arithmetic (DATE\_ADD, DATE\_SUB, ADDDATE, SUBDATE, INTERVAL units), differences (TIMESTAMPDIFF, TIMESTAMPADD, DATEDIFF, TIMEDIFF), extraction (EXTRACT, YEAR/MONTH/DAY/HOUR/MINUTE/SECOND/MICROSECOND, QUARTER, WEEK, DAYOFWEEK, WEEKDAY, LAST\_DAY), parsing/formatting (STR\_TO\_DATE, DATE\_FORMAT, GET\_FORMAT), Unix time (UNIX\_TIMESTAMP, FROM\_UNIXTIME), time-zone conversion (CONVERT\_TZ), construction (MAKEDATE, MAKETIME, SEC\_TO\_TIME), and Oracle-compat helpers (ADD\_MONTHS, MONTHS\_BETWEEN, TO\_DATE).                                        |
| `mariadb-numeric-functions`      | `dev`, `sql` | MariaDB numeric and math functions — rounding/truncation (ROUND, the TRUNCATE function vs the TRUNCATE TABLE statement, FLOOR, CEILING, SIGN, ABS), integer-vs-decimal division (the DIV operator vs /, MOD / %), powers and logs (POW/POWER, SQRT, EXP, LN, LOG, LOG2, LOG10), trigonometry (SIN, COS, TAN, ASIN, ACOS, ATAN, ATAN2, COT, PI, DEGREES, RADIANS), randomness (RAND, seeded RAND(N)), base conversion (CONV, OCT, BIN, HEX), checksums (CRC32, CRC32C), and number formatting (FORMAT).                                                                                                                                                                                                       |
| `mariadb-aggregate-functions`    | `dev`, `sql` | MariaDB aggregate functions — calculations across a set of rows (typically with GROUP BY or as window functions via OVER()). Covers counting (COUNT, COUNT(DISTINCT)), totals/averages (SUM, AVG), extrema (MIN, MAX), string aggregation (GROUP\_CONCAT with DISTINCT/ORDER BY/SEPARATOR/LIMIT), bitwise aggregation (BIT\_AND, BIT\_OR, BIT\_XOR), and the statistical family (STD/STDDEV/STDDEV\_POP, STDDEV\_SAMP, VARIANCE/VAR\_POP, VAR\_SAMP).                                                                                                                                                                                                                                                        |
| `mariadb-control-flow-functions` | `dev`, `sql` | MariaDB control-flow functions and operators — IF(), IFNULL()/NVL(), NULLIF(), COALESCE(), the CASE operator (simple and searched forms), NVL2(), and DECODE/DECODE\_ORACLE.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| `mariadb-window-functions`       | `dev`, `sql` | MariaDB window functions — ranking (ROW\_NUMBER, RANK, DENSE\_RANK, PERCENT\_RANK, CUME\_DIST, NTILE), value navigation (LAG, LEAD, FIRST\_VALUE, LAST\_VALUE, NTH\_VALUE), and ordered-set/inverse-distribution functions (MEDIAN, PERCENTILE\_CONT, PERCENTILE\_DISC), plus the OVER (PARTITION BY ... ORDER BY ... frame) clause, named windows (WINDOW w AS (...)), and ROWS/RANGE window frames.                                                                                                                                                                                                                                                                                                        |
| `mariadb-information-functions`  | `dev`, `sql` | MariaDB information functions — session and server metadata: LAST\_INSERT\_ID, ROW\_COUNT, FOUND\_ROWS, DATABASE/SCHEMA, USER/CURRENT\_USER/SESSION\_USER/SYSTEM\_USER, CURRENT\_ROLE, VERSION, CONNECTION\_ID, CHARSET, COLLATION, COERCIBILITY, BENCHMARK, DEFAULT, LAST\_VALUE, ROWNUM, BINLOG\_GTID\_POS, DECODE\_HISTOGRAM.                                                                                                                                                                                                                                                                                                                                                                             |
| `mariadb-vector-functions`       | `dev`, `sql` | MariaDB vector functions — VEC\_Distance, VEC\_Distance\_Euclidean, VEC\_Distance\_Cosine, VEC\_FromText, VEC\_ToText, and the VECTOR data type / MHNSW vector index context.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| `mariadb-encryption-functions`   | `dev`, `sql` | MariaDB encryption, hashing, and compression functions — AES\_ENCRYPT/AES\_DECRYPT keyed off block\_encryption\_mode (default aes-128-ecb) with optional IV/mode since 11.2; SHA2/SHA1/MD5 checksums; KDF and RANDOM\_BYTES for key derivation; COMPRESS/UNCOMPRESS/UNCOMPRESSED\_LENGTH; PASSWORD/OLD\_PASSWORD/ENCRYPT for auth hashing; ENCODE/DECODE (weak, not removed) vs DES\_ENCRYPT/DES\_DECRYPT (removed in 13.0).                                                                                                                                                                                                                                                                                 |

<sub>*This page is licensed: GPLv2*</sub>

{% @marketo/form formId="4316" %}
