PATM: Handle SQL-based databases and provide useful tools and workflows, all in one app!

Hey everyone!

I wanted to share a project I've been working on called PATM (Short for "Pipeline automation tools manager". It's an open-source (Licensed under GPL 3.0), QT6-based project designed to help you manage a database and provide useful tools without having to write any code or queries from scratch, for now it is available only on Linux, but i might later add support for Windows (specifically 10 and 11).

You can check out the source code and documentation here:

jamalhill12321-hash / patm

PATM - Pipeline Automation Tool Manager. Qt6 desktop app for database automation with embedded Python tools.

PATM

A desktop app for people who are tired of writing throwaway scripts to move data between databases. Connect, query, tools, all in one place.

GPL-3.0-or-later · v0.0.0-experimental · currently available for Linux only, might make it available to Windows later.

Presentation

https://youtu.be/5DlpbQOPMj8

What it does

• Connect to PostgreSQL, MySQL, or MariaDB : passwords stay in your system keyring, never in config files. Supports TLS and SSH tunnels.
• Browse tables : see what's in your database, double-click to preview.
• SQL query windows : write queries, highlight and execute just the selection (or all of it). Save/load .sql files. Results show up in a grid.
• SQL terminal : Get access to SQL with commands.
• Run tools : built-in CSV export and table transfer. Write your own Python tools; PATM sandboxes them through a restricted API so they can query data but never touch credentials.

Building

# Fedora
sudo dnf install gcc

…

View on GitHub

Get Involved!

I built this to solve the fatigue of writing hundreds of lines of code from scratch just to get an error because you misspelled a variable in the code, but I'd love to see it grow further since i spent a year (12 months) working on it. If you're a developer, hacker, or open-source enthusiast, I would deeply appreciate any eyes on the code.

Whether you want to optimize performance, inspect the architecture, or pick up an issue, contributions of all kinds are welcome! Feel free to express your opinions or drop your thoughts below.