QueryGlow

Environments

QueryGlow uses color-coded environments to provide visual warnings when working with production databases. Combined with Safe Mode, this helps prevent accidental DROP TABLE disasters.

Two Layers of Protection

QueryGlow protects your data with two independent features:

1. Environment Labels

Per-connection visual indicators (this page)

2. Safe Mode

Global query blocking (Query Editor)

Environment Labels

When you create a connection, you assign it an environment. This adds a color indicator throughout the UI to remind you what kind of database you're working with.

DevelopmentGreen

For local databases, test containers, and experimentation. Green accent throughout the UI.

StagingYellow

For pre-production testing environments. Yellow accent reminds you this data may matter.

Production Red

For live customer data. Red accent + warning banner throughout the UI reminds you to be extra careful.

What Environment Labels Do

✓ Visual Warnings

Color-coded UI elements remind you which database you're connected to.

✓ Warning Banners

Production connections display a red warning banner.

✗ Query Blocking

Environment labels do NOT block queries. That's what Safe Mode does.

✗ Per-Environment Rules

There are no different confirmation dialogs per environment.

Safe Mode (The Real Protection)

While environment labels provide visual warnings, Safe Mode is what actually blocks dangerous queries.

Safe Mode blocks in the Query Editor:

  • • DROP TABLE / DROP DATABASE
  • • TRUNCATE
  • • DELETE / UPDATE without WHERE clause

Default: ON

QUERYGLOW_ALLOW_DESTRUCTIVE=false

Scope: Global

Applies to ALL connections, regardless of environment

Learn more: Query Editor |Environment Variables

Best Practice

Use both features together: Label your connections correctly so the visual warnings remind you to be careful, and keep Safe Mode enabled so dangerous queries are blocked even if you make a mistake.

How to Set an Environment

  1. Open the New Connection or Edit Connection dialog.
  2. Find the Environment dropdown.
  3. Select Development, Staging, or Production.
  4. Save the connection.

The environment setting is stored with the connection and can be changed anytime by editing the connection.