database-query

To securely query an external database, this tool executes SQL through shell commands with environment-based credential handling. It enforces a default read-only mode for SELECT queries and requires explicit user confirmation before performing any write operations.

Yes, you can export SQL query results as CSV or JSON files. The tool supports running SELECT queries against SQLite, MySQL, and PostgreSQL databases and directly exporting the retrieved data into these formats for analytics or data migration checks.

Yes, this tool supports inspecting table schemas in PostgreSQL, as well as SQLite and MySQL. It provides dialect-specific command guidance to retrieve details about tables, columns, and indexes for safe data exploration and app development.

Database credentials for MySQL connections are processed using environment-based credential handling. This approach securely manages authentication without exposing sensitive information directly in the command interface or query execution flow.

The best way to prevent accidental data writes is using the default read-only mode. This safety control automatically restricts operations to SELECT queries, requiring explicit user confirmation before authorizing any potentially destructive write commands to the database.

Yes, you can run database queries for analytics without standard client interfaces. The tool connects to SQLite, MySQL, and PostgreSQL directly through shell commands, utilizing dialect-specific guidance to execute queries and export results.