sql-database

To execute safe SQL queries without data loss, use a read-only mode by default for SELECT operations and enforce parameterization. This prevents destructive operations, allowing mutations only when explicitly approved.

You can inspect a database schema by listing tables and viewing their CREATE statements. This schema exploration reveals the underlying data structures without requiring direct, risky interactions with the data itself.

Yes, you can run SQL queries against SQLite and other relational databases like Postgres. The skill supports schema inspection and query execution across multiple relational database systems safely.

The best way to identify SQL query anti-patterns is to use query optimization guidance features. These analyze your statements, detect common inefficiencies, and suggest safe improvements for better performance.

You should use parameterized SQL queries to prevent SQL injection and ensure safe database exploration. Parameterization separates code from data, enforcing read-only safety by default and blocking destructive operations.

Database mutations are not allowed by default during schema inspection. The system operates strictly in read-only mode, permitting data modifications only when you grant explicit approval for those specific operations.