Back to articles
Manage Your SQL Databases via Terminal with This App

Manage Your SQL Databases via Terminal with This App

via Dev.toMarcos Oliveira

For developers, DBAs, and analysts who need a lightweight, fast, and powerful tool for working with multiple databases in the terminal. Pam is a minimalist command-line interface (CLI) tool written in Go , designed to simplify managing and executing SQL queries across multiple databases. Inspired by “The Office,” Pam pays homage to the character who organizes everything efficiently. Key Features Query Library: Save and organize your most-used SQL queries for easy access and reuse. Multi-database Support: Compatible with PostgreSQL, MySQL, SQLite, Oracle, SQL Server, ClickHouse, and Firebird. TUI (Terminal User Interface) : Keyboard-focused navigation with Vim-inspired shortcuts for efficient manipulation of query results. Direct Editing: Update cells, delete rows, and edit SQL directly in the results table. Data Export: Export results in formats such as CSV , JSON , SQL, Markdown , or HTML . Parameterized Queries: Support for parameterized queries, enabling dynamic searches without rew

Continue reading on Dev.to

Opens in a new tab

Read Full Article
3 views

Related Articles