theanurin/sqlrunner repository overview

⁠SQL Runner

SQL Runner - provides ability to run series of SQL scripts against various databases like MSSQL, MySQL, PostgreSQL, SQLite, etc.

⁠Status

⁠Image reason

• Base image for self-execution SQL jobs. To embed into CD processes.
• Apply series of SQL scripts for development purposes

⁠Spec

⁠Environment variables

• DATABASE_URL - URL representation of connection string
  • mysql://user:password@host-or-ip:port/db
  • postgres://user:password@host-or-ip:port/db
  • postgres+ssl://user:password@host-or-ip:port/db
  • sqlite:///path/to/my.db
• DATA_DIRECTORY - Default /data. Override path to SQL scripts.

⁠Volumes

• /data - where the tool look for SQL scripts

⁠Inside

• Alpine Linux⁠
• SQL Runner Tool (written on Node.js)

⁠Launch for development purposes

SQL_SCRIPTS_PATH=/path/to/sql-scripts
DATABASE_URL=postgres://user:password@host-or-ip:port/db

docker run --rm --interactive --mount "type=bind,source=${SQL_SCRIPTS_PATH},target=/data" --env DATABASE_URL theanurin/sqlrunner