querycommander 0.9.6

Browser-based SQL Query Tool for Universal Database Management

Query Commander ·

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

Features:

1. Database Connectivity

   • Support for multiple server connections and heterogeneous targets
   • Support for multiple database types:
     (Oracle, PostgreSQL, Redshift, MySQL, Trino, Presto, etc.)

2. Database Management

   • Viewing of database objects
   • Browse Schemas
   • Data export capabilities
   • Explain Plain visualization

3. Metadata Access

   • View table structures, constraints, indexes, relationships, roles, and permissions
   • Generate ddl for views, materialized views, procedures, functions, and much more

4. 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

5. 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

6. 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]

Learn More

Read the Documentation