Query Commander ·

Introducing Query Commander, the opensource browser-based SQL tool designed for secure and efficient database management.

Features:

Database Connectivity
- Support for multiple server connections and heterogeneous targets
- Support for multiple database types:
  (Oracle, PostgreSQL, Redshift, MySQL, Trino, Presto, etc.)
Database Management
- Viewing of database objects
- Browse Schemas
- Data export capabilities
- Explain Plain visualization
Metadata Access
- View table structures, constraints, indexes, relationships, roles, and permissions
- Generate ddl for views, materialized views, procedures, functions, and much more
User Interface
- Intuitive, familiar, and user-friendly interface
- Browser-based multi-tab and multi-window interface
- SQL Editor: Custom SQL Execution and results display
- Syntax highlighting
Enhanced Security
- Support for End-to-End Encryption
- Multiple authentication options (Database login-based, LDAP/Active Directory)
- Optional time-based rate limits for queries executed and/or total records retrieved by user
- Advanced permissions management with "Persona proxies" and group-based authorization
- Ideal for cloud-hosted and remote database server access
- Support for AWS Secret Manager for secure credential storage and database server info
Modern Hosting Options
- Traditional installation with CGI executions
- Optional Serverless installation (AWS API Gateway, Lambda, S3, DynamoDB, and Secrets Manager)

Installation

» Check out the Apache 2.x and AWS Lambda installation options.

General Installation

For local installations the easiest way to get started is to use pip as shown below:

pip install querycommander

The above installs the basic software with no built-in connectors. To install specific connectors or components use one or more of the following commands:

# Database Connectors
pip install querycommander[postgres]
pip install querycommander[mysql]
pip install querycommander[oracle]
pip install querycommander[redshift]
pip install querycommander[trino]

# Other connectors
pip install querycommander[aws] # For DynamoDB, S3, and SecretsManager features
pip install querycommander[redis] # For Redis session token storage
pip install querycommander[ldap]  # For LDAP authentication

# Install everything in one command
pip install querycommander[all]