Skip to main content

Browser-based SQL Query Tool for Universal Database Management

Project description

Query Commander · GitHub license Python Versions Read the Docs GitHub release (latest by date)

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

Basic Screenshot

Features:

  1. Database Connectivity

    • Support for multiple database types (Oracle, PostgreSQL, Redshift, MySQL, etc.)
    • Support for multiple server connections and heterogeneous targets
  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
  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

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 and only includes AWS integrations by default. 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]

# Other connectors
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

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

querycommander-0.6.2.tar.gz (453.0 kB view details)

Uploaded Source

Built Distribution

querycommander-0.6.2-py3-none-any.whl (202.2 kB view details)

Uploaded Python 3

File details

Details for the file querycommander-0.6.2.tar.gz.

File metadata

  • Download URL: querycommander-0.6.2.tar.gz
  • Upload date:
  • Size: 453.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.1.1 CPython/3.11.2

File hashes

Hashes for querycommander-0.6.2.tar.gz
Algorithm Hash digest
SHA256 359465871acfda459aa71f1bc02f849e2511c56ca3278ae2331d8d206828f94b
MD5 84d4ca806450fc2cc3ceb548c08d8b9e
BLAKE2b-256 9345a0d5bb822a478d8a7baf9e3a969e4ff39d6cb984b6a41729b610a6ccdee7

See more details on using hashes here.

File details

Details for the file querycommander-0.6.2-py3-none-any.whl.

File metadata

File hashes

Hashes for querycommander-0.6.2-py3-none-any.whl
Algorithm Hash digest
SHA256 32da2d20c5b75f93790499956f953c40a7dbb4b5c2fd460fe736fe7e92a90649
MD5 4b8402caee1c7fa8378a2ad36e5592b8
BLAKE2b-256 d8ba1e993f2c9d9f55fd09ef293ff77b55280ed57e90b8603895d3494dd464d5

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page