Prevent Data Breach and Ensure GDPR Compliance for Your Database

WHY Bytebase
TutorialStep-by-step guide through common features.
Start Learning
Pricing

...Cloud Self-host

WHY Bytebase
Pricing
GitHub

Self-host Cloud

Engine

Enforce InnoDB storage engine

Table

Enforce inclusion of primary key in a table
Prohibit using foreign key constraints
Restrict the naming format of tables to be deleted
Prohibit using partition table
Prevent the use of triggers on tables
Table comment convention
Disallow duplicate indexes
Restrict the total length of text fields in a table
Prohibit defining character set in table properties
Disallow DDL
Disallow DML
Limit DDL operations on tables with a large number of rows

Statement

Prohibit using "SELECT *"
Enforce the presence of "WHERE" condition in SELECT statements
Enforce the presence of "WHERE" condition in UDPATE/DELETE statements
Prohibit using leading wildcard in filter conditions
Prohibit explicit "COMMIT" statement
Prohibit using CASCADE option for ON DELETE clauses
Prohibit using CASCADE when removing a table
Prohibit using "LIMIT" clause in DML statements
Prohibit using "ORDER BY" clause in "UPDATE" and "DELETE" statements
Prohibit issuing multiple independent changes on the same table
Enforce specifying column names in "INSERT" statements
Prohibit using "ORDER BY rand()" in "INSERT" statement
Restrict the maximum number of inserted rows
Restrict the maximum number of updated or deleted rows (estimated).
Validate the executability of DML statements
Restrict adding columns with default values to a table
Enforce including "NOT VALID" option when adding "CHECK" constraints
Restrict adding "NOT NULL" constraint to existing columns
Check full table scan for queries
Prohibit creating objects without specifying the schema
Check if Set Role statement at the beginning
Prohibit using filesort
Prohibit using temporary tables
Prohibit using NULL equality comparison in WHERE clause
Restrict the maximum level of query access method
Restrict the number of values in the IN or OR clause of the WHERE clause
Restrict the maximum number of the LIMIT clause
Restrict the number of tables to be joined
Restrict the number of statements in a transaction
Fields to be joined must have identical data types, character sets
Disallow mixing DDL and DML
Check no position in ADD COLUMN clause
Disallow Offline DDL
Disallow cross database queries
Enforce including "NOT VALID" option when adding foreign keys
Detect and report non-transactional statements

Naming

Fully qualified object name
Enforce table naming format
Prohibit using keywords as table names
Enforce column naming format
Enforce unique key naming format
Enforce primary key naming format
Enforce index naming format
Enforce foreign key naming format
Enforce auto-increment column naming format
Prohibit using keywords as identifiers
Enforce identifier case

Column

Enforce the inclusion of specific columns in a table
Prohibit the use of certain column data types
Enforce "NOT NULL" constraints on columns
Prohibit modifying column types
Prohibit dropping columns
Prohibit dropping columns in index
Enforce default value on "NOT NULL" columns
Prohibit using "CHANGE COLUMN" statement
Prohibit changing the order of columns in a table
Enforce the use of "INTEGER" data type for auto-increment columns
Prohibit defining character set in column properties
Enforce the use of "UNSIGNED" data type for auto-increment columns
Table comment convention
Restrict the length of "CHAR" data type
Restrict the length of "VARCHAR" data type
Restrict the initial value of auto-increment columns
Restrict the number of columns in the table that acquire system time
Enforce setting default value on columns
Disallow setting volatile default value on columns

Schema

Check application backward compatibility

Database

Prohibit deleting non-empty database

Index

Prohibit indexes containing duplicate columns
Prohibit creating indexes on "BLOB" and "TEXT" data type columns
Primary key type limit
Restrict the number of columns in a single index
Restrict the number of indexes on a single table
Allowable list of primary key types
Enforce concurrent index creation
Allowable list of index types
Disallow redundant indexes

System

Allowable list of Charset
Allowable list of Collation
Restrict the length of comments
Disallow to create procedures
Disallow to create events
Disallow to create views
Disallow to create functions
Prohibit the use of certain functions

Advice

Online migration

SQL Review Guide

An online tool for DBA to generate the SQL review / DDL guideline.

Template

Advanced
Comprehensive policy where you have total protection and best practices for your databases.
Basic
Basic coverage to defend your databases from common misusage.

Category

MySQL333
MariaDB297
TiDB286
PostgreSQL238
Oracle153
OceanBase (Oracle)142
OceanBase302
Snowflake107
SQL Server125
Error187
Warning174

Rules

Engine
- Enforce InnoDB storage engine
Table
Statement
Naming
Column
Schema
- Check application backward compatibility
Database
- Prohibit deleting non-empty database
Index
System
Advice
- Online migration

Database Review Guide

Engine

Error
Enforce InnoDB storage engine
InnoDB is the default storage engine for MySQL that provides transaction support. It also provides better performance for high-concurrency and low-latency scenarios, and supports online data backup and recovery. It is the preferred choice for OLTP businesses. Suggestion error level: Error

Table

Error
Enforce inclusion of primary key in a table
Various data synchronization, comparison, and rollback tools require tables to have primary key. Suggestion error level: Error
Error
Prohibit using foreign key constraints