SQL Simulator

SQL Simulator is a bleeding edge CI/CD tool for SQL Server. It’s a Kubernetes app that leverages SQL scripts to generate subsetted databases within a secure Sandbox environment. With SQL Simulator, there's no need to rewrite SQL statements for testing purposes. The tool automatically constructs and populates tables, including those with foreign keys, based on common SQL commands such as insert, update, delete, create table, and select.

One notable feature of SQL Simulator is its self-destruct mechanism. Any databases created by the tool will automatically delete themselves after 15 minutes of inactivity, enhancing security and resource management.

Moreover, SQL Simulator incorporates a data governor to regulate database access. This governor imposes restrictions on the number of keys retrievable from tables, both in terms of daily limits and per-request quotas. For instance, users can specify limits such as allowing only one Social Security Number (SSN) to be retrieved across all tables within a database. This ensures data usage compliance and prevents the potential for a massive data breach if you are hacked.

This databases supported by this tool are Oracle, SQL Server, Azure SQL, MySQL and Postgres.