skills.rest
mariadb-corporation
mariadb-corporationOFFICIAL
Explore all skills by this author →
WebsiteGitHub

mariadb-show

Guides writing and reviewing MariaDB SHOW statements with correct syntax and terminology.

28|115|Updated Jan 28, 2025
Search Tags:#SQL#replication#database administration#mariadb#information_schema#query diagnostics#show statement
One-click install
npx skills add https://github.com/mariadb-corporation/mariadb-docs --skill mariadb-show-mariadb-corporation
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mariadb-show
Source: https://github.com/mariadb-corporation/mariadb-docs/tree/main/agent-skills/granular/statements/mariadb-show
Command: npx skills add https://github.com/mariadb-corporation/mariadb-docs --skill mariadb-show-mariadb-corporation

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? MariaDB's SHOW statement family has non-standard spellings, a generic plugin-table fallback, and filtering rules that differ from standard SQL, so LLM-generated SHOW statements often use outdated MASTER/SLAVE terminology or assume LIKE/WHERE work everywhere. ## Core Features & Use Cases - Replication SHOW Terminology: Maps legacy MASTER/SLAVE spellings to preferred BINLOG/REPLICA forms while noting that status counters still use slave/master naming. - Extended SHOW Filtering: Documents exactly which SHOW forms accept LIKE/WHERE clauses and which use LIMIT or no filter at all. - Live Query Diagnostics: Covers SHOW EXPLAIN and SHOW ANALYZE for inspecting a query running in another connection, plus plugin-registered SHOW variants like USER_STATISTICS and WSREP_MEMBERSHIP. - Use Case: When reviewing a migration script containing SHOW MASTER STATUS, rewrite it as SHOW BINLOG STATUS and verify the monitoring queries still match status counters by name. ## Quick Start Ask the AI to write or review a MariaDB SHOW statement, such as generating the correct syntax to check replica status and filter session variables.

Frequently Asked Questions about mariadb-show

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

FAQPage Schema
How do I check replication status in MariaDB?▼

Use SHOW REPLICA STATUS, the preferred MariaDB spelling; SHOW SLAVE STATUS still works because REPLICA is a lexer-level synonym for SLAVE. For multi-source setups, append a connection name or use SHOW ALL REPLICAS STATUS.

What is the difference between SHOW MASTER STATUS and SHOW BINLOG STATUS?▼

They are the same command internally; SHOW BINLOG STATUS is the preferred MariaDB spelling and SHOW MASTER STATUS is kept as a legacy alias. From MariaDB 12.3, the output also includes a Gtid_Binlog_Pos column.

Which MariaDB SHOW statements support WHERE and LIKE clauses?▼

Only a fixed subset called Extended SHOW accepts both, including SHOW TABLES, SHOW STATUS, SHOW VARIABLES, SHOW COLUMNS, and SHOW INDEX. Statements like SHOW REPLICA STATUS, SHOW ENGINE, and SHOW GRANTS take no filter, while SHOW WARNINGS uses LIMIT instead.

How can I see the execution plan of a query running in another MariaDB session?▼

Use SHOW EXPLAIN FOR <connection_id> or SHOW ANALYZE FOR <connection_id>, getting the id from SHOW PROCESSLIST. SHOW ANALYZE additionally returns live runtime counters without waiting for the query to finish.

Why does SHOW USER_STATISTICS return no rows in MariaDB?▼

The userstat feature is gated behind the userstat system variable, which defaults to OFF. Enable it with SET GLOBAL userstat = 1 before per-user, per-table, or per-client activity counters appear.

Does SHOW TABLES in MariaDB list only tables?▼

No, SHOW TABLES also lists sequences and views. SHOW FULL TABLES reports the Table_type column as BASE TABLE, VIEW, or SEQUENCE so you can distinguish object types.

Related Skills

Explore More Software Engineering Skills→
adriancodesadriancodes

ecc-mysql-patterns

Reviews MySQL and MariaDB schemas, indexes, queries, transactions, and configuration from supplied evidence.

Community
Intermediate
Marwan78888Marwan78888
16

postgres-pro

Diagnose and optimize PostgreSQL query plans, indexes, and replication workflows.

Community
Advanced
selrai-companyselrai-company

postgresql-optimization

Analyze EXPLAIN ANALYZE and pg_stat_statements to recommend PostgreSQL indexes and configuration.

Official
Advanced
anthropicsanthropics
37

snowflake-api

Execute SQL statements against Snowflake and retrieve query results.

Official
Advanced