luis-sousa-pinto / inquery Goto Github PK

Superpowers for your SQL database

Docs | Slack | Website

• Alerts: Receive notifications when a change occurs
• Audit History: View all historical changes with context
• Query Preview: Preview affected rows and query plan prior to running changes
• Approval Flow: Require query review before a change can be run
• Branching: Git-like version control
• Instant Rollback: Instantly rollback to any commit

Alerts can be used to send notifications when a database change is made (INSERT, UPDATE, DELETE).

• Send notifications to Slack, email, or any other webhook
• Filter-out changes made by application users to only see manual updates
• Use template strings (column values, user, etc.) to see what was changed and by who

1. Data is modified in a Postgres table (INSERT, UPDATE, DELETE)
2. A Postgres trigger notifies the Inquery web server via a websocket message
3. Inquery formats, filters, and sends the data to configured webhook(s)

View all manual data updates that occurred in your Postgres database, even those that weren't initiated through the Inquery UI.

Before executing a query, check which tables and rows will be affected. View exactly which columns will be updated and their new value. Explore the visual query plan generated from EXPLAIN.

Submit a query for approval by teammates instead of running them directly against the production database. Auto-approval rules can be configured based on the number of rows changed, the table being updated, or the user's role.

You can run Inquery locally with Docker.

git clone --depth 1 https://github.com/inqueryio/inquery.git
cd inquery
docker-compose up -d

Then open http://localhost:3000 to access Inquery.

Note: When connecting your database, if your Postgres host is localhost, you must use host.docker.internal instead to access it when running with Docker.

Note: Make sure this instance is only accessible within your VPC.
Note: Make sure your local machine is able to connect to the server on port 3000 (the web server) and 3003 (the API server) over HTTP.
Note: These instructions are for Amazon Linux 2 AMI (HVM).

1. To install Docker, run the following command in your SSH session on the instance terminal:

sudo yum update -y
sudo yum install -y docker
sudo service docker start
sudo usermod -a -G docker $USER
logout # Needed to close the SSH session so Docker does not have to be run as root

2. To install docker-compose, run the following command in your ssh session on the instance terminal:

sudo curl -L "https://github.com/docker/compose/releases/download/v2.16.0/docker-compose-$(uname -s)-$(uname -m)"  -o /usr/local/bin/docker-compose
sudo mv /usr/local/bin/docker-compose /usr/bin/docker-compose
sudo chmod +x /usr/bin/docker-compose
docker-compose version

3. Install and run Inquery

mkdir inquery && cd inquery
wget https://raw.githubusercontent.com/inqueryio/inquery/main/{.env,docker-compose.yml,.dockerignore,frontend.env}
docker-compose up -d

Sign up for Inquery Cloud early access and get a managed, cloud-hosted instance.

Let us know your feedback or feature requests! You can submit a GitHub issue or contact us at [email protected].