From mariadb-mcp
Use when you need to work with MariaDB databases, write or review SQL, design schemas, optimize queries, configure Hibernate/QueryDSL for MariaDB, or troubleshoot database performance issues. Trigger with phrases like "mariadb", "database schema", "hibernate mapping", "querydsl", "slow query", "index not used", "collation", "mariadb performance", "database migration", "replication", "backup database".
How this skill is triggered — by the user, by Claude, or both
Slash command
/mariadb-mcp:mariadb-best-practicesThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
Comprehensive MariaDB guidance for schema design, indexing, query optimization,
Comprehensive MariaDB guidance for schema design, indexing, query optimization, Hibernate/QueryDSL integration, performance tuning, security, backup/replication, and migrations.
This skill is a router. It identifies what you need and directs you to the
right reference document. All reference files are in references/ relative to
this skill file.
If MariaDB MCP tools are available in this session, always use them to
validate recommendations against the actual database state. Don't give
theoretical advice when you can check SHOW CREATE TABLE, SHOW COLLATION,
EXPLAIN, SHOW GLOBAL STATUS, etc.
Based on what the user needs, read the relevant reference file(s):
references/schema-design.mdreferences/hidden-gotchas.md (collation and charset traps)references/indexing.mdreferences/hidden-gotchas.md (collation mismatches, implicit conversions)references/query-optimization.mdreferences/hidden-gotchas.md (optimizer traps)references/hibernate-querydsl.mdreferences/hidden-gotchas.md (type mapping pitfalls)@Entity, @Column, JPAQueryFactory, QClass filesreferences/performance-tuning.mdSHOW GLOBAL STATUS, SHOW VARIABLES, buffer pool hit ratioreferences/security-hardening.mdreferences/backup-replication.mdreferences/migrations.mdreferences/hidden-gotchas.md (collation in DDL, ALTER TABLE locking)These apply regardless of task type:
Always check collations. When any query involves JOINs or comparisons across tables, verify that the joined/compared columns have matching collations. Mismatched collations silently disable index usage.
Always check for implicit type conversions. A WHERE clause comparing a VARCHAR column to an INT literal will cause a full table scan. Check EXPLAIN.
Prefer utf8mb4 over utf8. MariaDB's utf8 is actually utf8mb3 and cannot
store 4-byte Unicode characters (emoji, some CJK). Always use utf8mb4.
Validate against actual state. If MariaDB MCP is connected, always verify
recommendations by querying the actual database before presenting them. Run
SHOW CREATE TABLE, check INFORMATION_SCHEMA, use EXPLAIN.
Hibernate dialect matters. Ensure the project uses org.hibernate.dialect.MariaDBDialect
(or version-specific variant), not a MySQL dialect. Wrong dialect = wrong DDL generation.
When MariaDB MCP is available, these tools are at your disposal:
list_databases — Enumerate all databaseslist_tables — List tables in a databaseget_table_schema — Column definitions, types, keysget_table_schema_with_relations — Schema + foreign key relationshipsexecute_sql — Run SELECT, SHOW, DESCRIBE, EXPLAIN queriescreate_database — Create new databasesUse these to validate any recommendation before presenting it.
Searches MemPalace before answering questions about past work, people, projects, or prior decisions. Returns verbatim stored content instead of guessing from model memory.
Guides Payload CMS config (payload.config.ts), collections, fields, hooks, access control, APIs. Debugs validation errors, security, relationships, queries, transactions, hook behavior.
Implements vector databases with Pinecone, Weaviate, Qdrant, Milvus, pgvector for semantic search, RAG, recommendations, and similarity systems. Optimizes embeddings, indexing, and hybrid search.
npx claudepluginhub stefanfaur/roach-marketplace --plugin mariadb-mcp