SQL Runner

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

Status

Server	Readiness
MSSQL	❌
MySQL	❌
PostgreSQL	✅
SQLite	❌

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