Database Tools

Overview

This skill combines tools for PostgreSQL, MySQL, and Microsoft SQL Server (MSSQL).

Capabilities/Tools

You have three specialized query scripts located in scripts/:

• PostgreSQL: scripts/postgres_query.py
• MySQL: scripts/mysql_query.py
• MSSQL: scripts/mssql_query.py

These scripts allow you to securely connect to a database using predefined alias configurations, execute read/write queries, explain plans, and format output. DO NOT attempt to write your own psycopg2 or pymysql wrappers; always use these scripts unless explicitly told otherwise.

Permissions & Safety

The query scripts analyze every SQL statement before execution. Read-only queries (SELECT, SHOW, EXPLAIN) will execute directly. Write queries (INSERT, UPDATE, DELETE, DROP, ALTER, etc.) will NOT execute implicitly.