Mysql Readonly Inspector

3. Prefer a direct MySQL driver only when the active runtime already exposes one of these drivers and you need a one-off fixed operation:
   • mysql.connector
   • pymysql
   • MySQLdb
4. If no direct driver is already available, use the bundled script for every operation:

python scripts/mysql_readonly.py <command> [flags]

5. If the script reports that no MySQL driver is installed, install the fallback driver and rerun:

python -m pip install PyMySQL

6. When in doubt, prefer the bundled script because it keeps the config format, output shape, paging limits, and safety checks consistent.

Allowed Operations

Use only these operations:

• Initialize or overwrite the saved connection config.
• List visible databases.
• List tables for one database.
• Describe one table's columns and indexes.
• Preview one table page by page.

Use only these commands:

python scripts/mysql_readonly.py init
python scripts/mysql_readonly.py list-databases
python scripts/mysql_readonly.py list-tables --database <db>
python scripts/mysql_readonly.py describe-table --database <db> --table <table>
python scripts/mysql_readonly.py preview-table --database <db> --table <table> --page 1 --page-size 50

Paging Rules

• Default page-size is 50.
• Maximum page-size is 200.
• Refuse requests to dump full tables or to bypass paging.
• Use page plus page-size to navigate. Do not emulate full exports by issuing many pages unless the user explicitly wants iterative inspection and the volume stays reasonable.

Direct Driver Use

Use direct driver access only if a supported driver is already present in the active runtime and you can stay inside the same fixed read-only operation set documented by this skill.

Mirror these exact behaviors when using a direct driver:

• list-databases: SHOW DATABASES
• list-tables: query information_schema.tables for one schema
• describe-table: query information_schema.columns and information_schema.statistics
• preview-table: run COUNT(*) plus paged SELECT * ... LIMIT ... OFFSET ...

Do not improvise additional SQL shapes. If a request needs anything outside those fixed operations, refuse it.

Output Expectations

• Prefer the bundled script's JSON output for structured answers.
• Summarize the findings for the user after reading the JSON.
• If a command fails, report the driver used, the failing command, and the precise error message.

Reference

Read references/mysql-readonly-reference.md when you need:

• the exact config schema
• allowed and rejected action examples
• fallback-driver behavior
• common failure handling