← all plugins

1. ▌
   mariadb-set · mariadb-corporation

   Explains MariaDB-specific SET syntax and behavior, including scope rules, the SET STATEMENT ... FOR extension, and persistence differences from MySQL.
   0
   repo stars
2. ▌
   mariadb-call · mariadb-corporation

   Documents MariaDB-specific CALL syntax and behavior, including optional parentheses, OUT/INOUT parameter binding, result sets, privileges, prepared statements, and recursion limits.
   0
   repo stars
3. ▌
   mariadb-dump · mariadb-corporation

   Explains MariaDB-specific defaults and traps of the mariadb-dump client for dev workflows, including consistent backups, routines/events flags, diffable dumps, idempotent seeding, and restore via the mariadb client.
   0
   repo stars
4. ▌
   mariadb-show · mariadb-corporation

   Explains MariaDB-specific SHOW statement syntax, including replication terminology, filtering rules, and diagnostic commands like SHOW EXPLAIN and SHOW ANALYZE.
   0
   repo stars
5. ▌
   mariadb-grant · mariadb-corporation

   Documents MariaDB-specific GRANT behavior, including privilege scope levels, implicit account creation, MariaDB-only privileges, roles, proxy grants, resource limits, and TLS options, to help write accurate GRANT statements.
   0
   repo stars
6. ▌
   mariadb-binlog · mariadb-corporation

   Decodes and replays MariaDB binary logs with correct flags: commented pseudo-SQL vs. executable BINLOG blobs, ANNOTATE_ROWS events, flashback undo SQL, and safe replay via the mariadb client.
   0
   repo stars
7. ▌
   mariadb-client · mariadb-corporation

   Covers MariaDB-specific behavior of the mariadb command-line client, including batch mode output, delimiter handling, safe-updates, charset detection, and TLS defaults, for writing or reviewing shell commands and scripts.
   0
   repo stars
8. ▌
   mariadb-delete · mariadb-corporation

   Covers MariaDB-specific DELETE syntax and behavior, including RETURNING, multi-table forms, temporal-table deletion, and DELETE vs TRUNCATE differences.
   0
   repo stars
9. ▌
   mariadb-import · mariadb-corporation

   Bulk-load text files into MariaDB tables using the mariadb-import client, covering table-name-from-filename rules, TAB defaults, --local vs server-side reads, duplicate handling, and parallel loads.
   0
   repo stars
10. ▌
    mariadb-insert · mariadb-corporation

    Documents MariaDB-specific INSERT syntax and behavior, including RETURNING, ON DUPLICATE KEY UPDATE, INSERT IGNORE, and various forms and modifiers, to help write and review INSERT statements.
    0
    repo stars
11. ▌
    mariadb-revoke · mariadb-corporation

    Explains MariaDB-specific REVOKE syntax and behavior, including the five grammar forms, privilege requirements, error semantics, and role/proxy revocation nuances.
    0
    repo stars
12. ▌
    mariadb-select · mariadb-corporation

    Covers MariaDB-specific SELECT syntax and behavior, including optimizer hints, LIMIT extensions, row locking, temporal queries, and file output.
    0
    repo stars
13. ▌
    mariadb-update · mariadb-corporation

    Documents MariaDB-specific UPDATE syntax and behavior, including single-table vs multi-table forms, assignment evaluation order, RETURNING with OLD_VALUE(), temporal tables, and common pitfalls. Use when writing, generating, or reviewing UPDATE statements targeting MariaDB.
    0
    repo stars
14. ▌
    mariadb-vector · mariadb-corporation

    Provides best practices for using MariaDB's built-in vector support for AI workloads, including SQL syntax for vector columns, indexes, distance functions, and RAG patterns.
    0
    repo stars
15. ▌
    mariadb-explain · mariadb-corporation

    Explains MariaDB-specific EXPLAIN and ANALYZE syntax, including FORMAT=JSON, SHOW EXPLAIN/ANALYZE FOR, and the standalone ANALYZE statement that executes queries.
    0
    repo stars
16. ▌
    mariadb-prepare · mariadb-corporation

    Explains MariaDB server-side prepared statements (PREPARE, EXECUTE, DEALLOCATE, EXECUTE IMMEDIATE), including syntax, allowed statements, placeholders, session scope, and restrictions. Use when writing or reviewing dynamic SQL for MariaDB.
    0
    repo stars
17. ▌
    mariadb-replace · mariadb-corporation

    Explains MariaDB's REPLACE statement: its delete-then-insert behavior, when it triggers, data-loss risks, and the upsert alternative. Use when writing or reviewing REPLACE statements.
    0
    repo stars
18. ▌
    mariadb-features · mariadb-corporation

    Explains MariaDB-specific features and behaviors that differ from MySQL, including system-versioned tables, RETURNING, sequences, and version-specific defaults, to help optimize and migrate MariaDB applications.
    0
    repo stars
19. ▌
    mysql-to-mariadb · mariadb-corporation

    Guides developers migrating applications from MySQL to MariaDB, covering authentication, JSON handling, replication, and SQL syntax differences.
    0
    repo stars
20. ▌
    mariadb-drop-user · mariadb-corporation

    Explains MariaDB-specific behavior of DROP USER and RENAME USER, including multiple accounts per statement, IF EXISTS handling, active-connection warnings, and effects on privileges and definers. Use when writing or reviewing account-lifecycle SQL for MariaDB.
    0
    repo stars
21. ▌
    mariadb-load-data · mariadb-corporation

    Explains MariaDB-specific syntax and behavior for LOAD DATA [LOCAL] INFILE and LOAD XML, including LOCAL vs server-side file handling, security and privilege requirements, default tab/newline parsing, duplicate and strict-mode caveats, IGNORE n LINES, user-variable SET transforms, CHARACTER SET clause, and priority.
    0
    repo stars
22. ▌
    mariadb-alter-user · mariadb-corporation

    Covers MariaDB-specific ALTER USER and SET PASSWORD syntax, including IF EXISTS semantics, authentication methods, password expiration, account locking, and resource limits.
    0
    repo stars
23. ▌
    mariadb-drop-table · mariadb-corporation

    Documents MariaDB-specific DROP TABLE syntax and behavior, including RESTRICT/CASCADE no-ops, DROP TEMPORARY TABLE, partial drops, IF EXISTS warnings, foreign key references, views, triggers, implicit commit, and WAIT/NOWAIT. Use when writing, generating, or reviewing DROP TABLE statements targeting MariaDB.
    0
    repo stars
24. ▌
    mariadb-alter-table · mariadb-corporation

    Documents MariaDB-specific ALTER TABLE syntax and behavior, including online DDL algorithms, lock modes, lock timeouts, idempotent subclauses, system versioning, and partition operations, for writing and reviewing schema migrations.
    0
    repo stars
25. ▌
    mariadb-create-user · mariadb-corporation

    Documents MariaDB-specific CREATE USER syntax and behavior, including authentication chaining, TLS options, resource limits, password expiry, and account locking, to help write accurate statements.
    0
    repo stars
26. ▌
    mariadb-create-view · mariadb-corporation

    Explains MariaDB-specific view syntax and behavior, including CREATE OR REPLACE VIEW, ALGORITHM options, SQL SECURITY, updatability rules, and WITH CHECK OPTION, for writing or reviewing MariaDB view statements.
    0
    repo stars
27. ▌
    mariadb-lock-tables · mariadb-corporation

    Explains MariaDB explicit table locking (LOCK TABLES/UNLOCK TABLES) and named user-level locks (GET_LOCK family), covering alias traps, implicit commits, and multi-lock semantics for writing or reviewing locking code.
    0
    repo stars
28. ▌
    mariadb-create-index · mariadb-corporation

    Explains MariaDB-specific CREATE INDEX and DROP INDEX syntax, including mapping to ALTER TABLE, prefix lengths for TEXT/BLOB, lack of expression indexes, real descending indexes, IGNORED indexes, and index kinds. Use when writing or reviewing index statements for MariaDB.
    0
    repo stars
29. ▌
    mariadb-create-table · mariadb-corporation

    Covers MariaDB-specific CREATE TABLE syntax and behavior, including atomic CREATE OR REPLACE, invisible and compressed columns, temporal PERIOD clauses, ignored indexes, encryption, page compression, and the utf8/utf8mb4 distinction.
    0
    repo stars
30. ▌
    mariadb-rename-table · mariadb-corporation

    Provides MariaDB-specific syntax, atomicity, privilege requirements, and restrictions for RENAME TABLE statements, including multi-table swaps, temporary tables, and cross-database moves.
    0
    repo stars
31. ▌
    mariadb-transactions · mariadb-corporation

    Documents MariaDB-specific transaction control syntax and behavior, including START TRANSACTION, COMMIT, ROLLBACK, SAVEPOINT, implicit commit rules, autocommit defaults, and idle transaction timeouts.
    0
    repo stars
32. ▌
    mariadb-create-trigger · mariadb-corporation

    Covers MariaDB-specific CREATE TRIGGER syntax and behavior, including OR REPLACE, DEFINER, multiple trigger events, FOLLOWS/PRECEDES ordering, OLD/NEW rules, and restrictions. Use when writing, generating, or reviewing CREATE TRIGGER statements for MariaDB.
    0
    repo stars
33. ▌
    mariadb-json-functions · mariadb-corporation

    Catalog of MariaDB JSON functions with signatures and semantics, covering constructors, extraction, modification, merging, validation, introspection, and formatting. Use when writing SQL that builds, queries, or alters JSON data in MariaDB.
    0
    repo stars
34. ▌
    mariadb-truncate-table · mariadb-corporation

    Explains MariaDB-specific TRUNCATE TABLE semantics: DROP privilege, implicit commit, AUTO_INCREMENT reset, trigger and FK behavior, and restrictions on system-versioned tables and sequences.
    0
    repo stars
35. ▌
    mariadb-create-database · mariadb-corporation

    Provides MariaDB-specific syntax and behavior for CREATE, ALTER, and DROP DATABASE statements, including OR REPLACE vs IF NOT EXISTS, charset and collation defaults, and the absence of RENAME DATABASE.
    0
    repo stars
36. ▌
    mariadb-create-function · mariadb-corporation

    Explains MariaDB's three CREATE FUNCTION forms — stored functions, stored aggregate functions, and loadable UDFs — covering syntax, privileges, and behavior differences for writing or reviewing MariaDB SQL.
    0
    repo stars
37. ▌
    mariadb-create-sequence · mariadb-corporation

    Generates and reviews MariaDB CREATE SEQUENCE statements with version-specific syntax, defaults, and gotchas.
    0
    repo stars
38. ▌
    mariadb-set-transaction · mariadb-corporation

    Explains MariaDB-specific SET TRANSACTION behavior, including scope rules, isolation levels, and innodb_snapshot_isolation conflict detection, to help write correct transaction statements and retry logic.
    0
    repo stars
39. ▌
    mariadb-create-procedure · mariadb-corporation

    Documents MariaDB-specific CREATE PROCEDURE syntax, including OR REPLACE/IF NOT EXISTS exclusivity, DEFINER and SQL SECURITY behavior, parameter modes, DEFAULT values, advisory characteristics, privilege requirements, and the client-side DELIMITER convention.
    0
    repo stars
40. ▌
    mariadb-string-functions · mariadb-corporation

    Reference for MariaDB string functions: extraction, length, search, concatenation, modification, case, PCRE2 regex, formatting, and encoding, with common pitfalls and version notes.
    0
    repo stars
41. ▌
    mariadb-vector-functions · mariadb-corporation

    Reference for MariaDB's vector functions and VECTOR data type, covering VEC_Distance, VEC_Distance_Euclidean, VEC_Distance_Cosine, VEC_FromText, VEC_ToText, and MHNSW vector index usage for SQL queries over embeddings.
    0
    repo stars
42. ▌
    mariadb-window-functions · mariadb-corporation

    Reference for MariaDB window functions and the OVER clause, covering ranking, value navigation, and ordered-set functions with syntax and common pitfalls.
    0
    repo stars
43. ▌
    mariadb-connector-c-usage · mariadb-corporation

    Explains MariaDB Connector/C's `mysql_`-prefixed API, connection setup, result handling, prepared statements, and transaction behavior for writing or reviewing C code that talks to MariaDB.
    0
    repo stars
44. ▌
    mariadb-connector-j-usage · mariadb-corporation

    Explains MariaDB Connector/J JDBC driver behavior: auto-registration, URL schemes, prepared statement handling, batch inserts, transactions, fetch sizes, pooling, and failover. Use when writing or reviewing Java code that talks to MariaDB with the mariadb-java-client driver.
    0
    repo stars
45. ▌
    mariadb-numeric-functions · mariadb-corporation

    Reference for MariaDB numeric and math functions, covering rounding, division, powers, logs, trigonometry, randomness, base conversion, checksums, and formatting, with guidance on exact-vs-approximate types and division-by-zero behavior.
    0
    repo stars
46. ▌
    mariadb-rest-service-drop · mariadb-corporation

    Remove MariaDB REST service objects with DROP REST statements, including services, schemas, data mapping views, procedures, functions, content sets/files, auth apps, users, and roles, using IF EXISTS to avoid errors.
    0
    repo stars
47. ▌
    mariadb-rest-service-show · mariadb-corporation

    Browse and inspect MariaDB REST Service objects using read-only SHOW REST and SHOW CREATE REST statements to list services, schemas, views, procedures, functions, content sets, auth apps, roles, grants, and dump DDL for reverse-engineering or auditing.
    0
    repo stars
48. ▌
    mariadb-schema-management · mariadb-corporation

    Manages a MariaDB database schema across its lifecycle using the MariaDB Schema Management plugin via the mariadb-shell MCP server, covering project creation, versioned development, releases, and deployment.
    0
    repo stars
49. ▌
    mariadb-query-optimization · mariadb-corporation

    Provides best practices for optimizing MariaDB queries, including indexing strategies, EXPLAIN analysis, pagination, histogram statistics, and MariaDB-specific optimizer settings.
    0
    repo stars
50. ▌
    mariadb-aggregate-functions · mariadb-corporation

    Reference for MariaDB aggregate functions, covering counting, totals, extrema, string and bitwise aggregation, and statistical functions, with guidance on NULL handling and common pitfalls.
    0
    repo stars
51. ▌
    mariadb-connector-c-install · mariadb-corporation

    Installs and configures MariaDB Connector/C, covering package names per distribution, compile and link flags, option file handling, and TLS options.
    0
    repo stars
52. ▌
    mariadb-connector-cpp-usage · mariadb-corporation

    Covers MariaDB-specific behavior of the Connector/C++ sql:: API, including driver and connection setup, 1-based indexes, placeholder syntax, ResultSet iteration, raw pointer ownership, SQLString, autocommit, and exception handling.
    0
    repo stars
53. ▌
    mariadb-connector-j-install · mariadb-corporation

    Adds the MariaDB JDBC driver to a build, configures connection URLs and datasources, and sets up TLS with the correct sslMode and certificate options.
    0
    repo stars
54. ▌
    mariadb-date-time-functions · mariadb-corporation

    Reference for MariaDB's built-in date and time functions, covering current time, arithmetic, differences, extraction, parsing, formatting, Unix time, time-zone conversion, construction, and Oracle-compatible helpers, with guidance on version-specific behavior and common pitfalls.
    0
    repo stars
55. ▌
    mariadb-rest-service-create · mariadb-corporation

    Creates a MariaDB REST Service by configuring the REST metadata schema, creating the service and REST schema, and exposing tables, views, and routines as REST endpoints via SQL DDL in mariadb-shell.
    0
    repo stars
56. ▌
    mariadb-connector-odbc-usage · mariadb-corporation

    Explains MariaDB Connector/ODBC-specific behavior for application code, including DSN-less connection strings, positional parameter markers, prepared statement execution modes, autocommit defaults, TLS auto-enablement, and error handling. Use when writing or reviewing ODBC-based code (C/C++ or pyodbc) that talks to.
    0
    repo stars
57. ▌
    mariadb-encryption-functions · mariadb-corporation

    Reference for MariaDB's built-in encryption, hashing, and compression functions, covering AES_ENCRYPT/DECRYPT, SHA2, KDF, COMPRESS, and related functions, with guidance on correct usage and common pitfalls.
    0
    repo stars
58. ▌
    mariadb-schema-create-script · mariadb-corporation

    Guides writing MariaDB-specific database create scripts with best practices for schema objects, session settings, and UUID usage.
    0
    repo stars
59. ▌
    mariadb-connector-cpp-install · mariadb-corporation

    Installs and configures MariaDB Connector/C++ across Linux, Windows, and source builds, covering prerequisites, linking, and runtime plugin setup.
    0
    repo stars
60. ▌
    mariadb-connector-r2dbc-usage · mariadb-corporation

    Explains MariaDB Connector/R2DBC specifics for writing reactive Java code: URL scheme, placeholder binding, lazy execution, consume-once results, transactions, pooling, and error handling.
    0
    repo stars
61. ▌
    mariadb-information-functions · mariadb-corporation

    Reference for MariaDB information functions, covering session and server metadata such as LAST_INSERT_ID, ROW_COUNT, FOUND_ROWS, USER, and VERSION, with usage guidance for writing SQL that reads auto-increment IDs, row counts, and connection details.
    0
    repo stars
62. ▌
    mariadb-connector-nodejs-usage · mariadb-corporation

    Explains MariaDB Connector/Node.js specifics: Promise vs Callback API, placeholders, BigInt handling, batch inserts, query streams, pooling, transactions, and prepared statements, for writing or reviewing Node.js code that uses the `mariadb` package.
    0
    repo stars
63. ▌
    mariadb-connector-odbc-install · mariadb-corporation

    Installs and configures MariaDB Connector/ODBC, covering driver manager registration, DSN setup, connection-string keywords, and TLS options for Linux, macOS, and Windows.
    0
    repo stars
64. ▌
    mariadb-connector-python-usage · mariadb-corporation

    Explains MariaDB Connector/Python's DB API 2.0 behavior, including qmark placeholders, autocommit, prepared statements, buffered cursors, connection pooling, and error handling, for writing and reviewing Python code that uses the mariadb module.
    0
    repo stars
65. ▌
    mariadb-control-flow-functions · mariadb-corporation

    Reference for MariaDB control-flow functions and operators, including IF(), IFNULL(), NULLIF(), COALESCE(), CASE, NVL2(), and DECODE_ORACLE, with guidance on correct usage and common pitfalls.
    0
    repo stars
66. ▌
    mariadb-connector-r2dbc-install · mariadb-corporation

    Adds the MariaDB Connector/R2DBC reactive driver to a Maven or Gradle build and configures connection factories, pooling, and TLS, including the R2DBC-specific URL scheme and parameter names.
    0
    repo stars
67. ▌
    mariadb-system-versioned-tables · mariadb-corporation

    Best practices for MariaDB system-versioned (temporal) tables, covering creation, querying historical data, managing history growth, and handling ALTER TABLE operations.
    0
    repo stars
68. ▌
    mariadb-connector-nodejs-install · mariadb-corporation

    Installs and configures the MariaDB Connector/Node.js npm package, covering API entry points, TLS, and pooling.
    0
    repo stars
69. ▌
    mariadb-connector-python-install · mariadb-corporation

    Installs and configures MariaDB Connector/Python, covering the 1.1 and 2.0 lines, build prerequisites, and connection settings.
    0
    repo stars
70. ▌
    mariadb-schema-management-create · mariadb-corporation

    Scaffold a MariaDB Schema Management (MSM) project and author the initial schema in the development folder, creating the project with msm.create_project and writing the first version's tables, objects, and grants into the MSM sections of <schema>_next.sql.
    0
    repo stars
71. ▌
    mariadb-schema-management-deploy · mariadb-corporation

    Deploys a MariaDB Schema Management (MSM) schema version onto a live server using msm.deploy_schema, creating a fresh schema or upgrading an existing one, with optional backup.
    0
    repo stars
72. ▌
    mariadb-schema-management-develop · mariadb-corporation

    Develop the next version of a MariaDB Schema Management (MSM) schema by editing the development script and splitting large sections into SOURCE-included files.
    0
    repo stars
73. ▌
    mariadb-schema-management-release · mariadb-corporation

    Prepare a MariaDB Schema Management (MSM) version release by snapshotting the development script, filling the generated update script with the actual migration, and then generating the deployment script.
    0
    repo stars
74. ▌
    mariadb-rest-service-authorization · mariadb-corporation

    Configure authentication and authorization for a MariaDB REST Service: create REST auth apps, link them to services, add REST users, and manage REST roles and privileges.
    0
    repo stars
75. ▌
    mariadb-rest-service-update-endpoints · mariadb-corporation

    Modify existing MariaDB REST Service endpoints using ALTER and DROP REST statements, including renaming request paths, enabling/disabling, publishing, and merging JSON options.
    0
    repo stars