Keep your data safe with QuerySense

QuerySense, one of the unique features of TeamSQL, consistently checks your queries and detects any SQL statement that may cause a loss on your data and warns you before execution.

QuerySense watches for some SQL statements such as DELETE, DROP and TRUNCATE and asks for a confirmation. QuerySense is activated by default on all production connections. However, you can extend the activation of this feature to all connections types, even for development.

Supported Databases

TeamSQL QuerySense supports;

  • Oracle
  • MySQL
  • Microsoft SQL Server
  • PostgreSQL
  • AWS Redshift
  • Redis
  • Amazon Aurora
  • MariaDB
  • CitusData

Supported SQL Statements

QuerySense watches these SQL statements;

  • UPDATE
  • DELETE
  • INSERT
  • DROP
  • TRUNCATE
  • ALTER

Supported NoSQL Statements

QuerySense watches these Redis Commands;

  • FLUSHDB
  • FLUSHALL
  • PEXPIRE
  • DEL
  • SHUTDOWN
  • BGREWRITEAOF
  • BGSAVE
  • SAVE
  • SPOP
  • SREM
  • RENAME
  • SET
  • MOVE
  • MIGRATE
  • APPEND
  • CLUSTER RESET
  • CLUSTER FORGET
  • CLUSTER REPLICATE
  • CLUSTER ADDSLOTS
  • CLUSTER DELSLOTS
  • CLUSTER SAVECONFIG
  • CLUSTER SET-CONFIG-EPOCH
  • CLUSTER SETSLOT
  • CONFIG SET
  • CONFIG RESETSTAT

  • CONFIG REWRITE
  • CLIENT KILL
  • CLIENT SETNAME
  • RPUSH
  • RPUSHX
  • LINSERT
  • SADD
  • PUBLISH
  • RENAMENX
  • BRPOPLPUSH
  • RPOPLPUSH
  • SCRIPT FLUSH
  • SCRIPT KILL
  • GEOADD
  • HDEL
  • HMSET
  • HSET
  • HSETNX
  • PFADD
  • PFMERGE
  • EXPIREAT
  • PERSIST
  • PEXPIREAT
  • RESTORE
  • TOUCH

  • UNLINK
  • BLPOP
  • BRPOP
  • BRPOPLPUSH
  • LPOP
  • LPUSH
  • LPUSHX
  • LREM
  • LSET
  • RPOP
  • RPOPLPUSH
  • SMOVE
  • SUNION
  • SUNIONSTORE
  • ZADD
  • ZREM
  • ZREMRANGEBYLEX
  • ZREMRANGEBYRANK
  • ZREMRANGEBYSCORE
  • ZUNIONSTORE
  • PSETEX
  • SETBIT
  • SETEX
  • SETNX
  • SETRANGE

Ready to get started

Available on Windows, MacOS and Ubuntu platforms.