- connect to a database
- read all .sql files of current directory
- execute one after the other
- export results set as text (.csv) and Excel (.xslx)
- PostgreSQL
- Oracle
- MS SQL
- SQLite3
- scan SQL for dangerous commands like DROP/DELETE (incomplete!)
- Limits the max number of returned rows via limit on cells = columns * rows
- hashing of SQL files to prevent modification
- Excel: autosize column width
- use sqlparse to remove comments from SQL
example for PostgreSQL
GRANT SELECT ON ALL TABLES IN SCHEMA schema_name TO username
GRANT USAGE ON SCHEMA schema_name TO username
Oracle Instant Client - Basic Light Package from https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html download, unzip and add dir to path
Microsoft ODBC Driver for SQL Server from https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15 install