CLI Postgres Tool Written in Python
Benji Asperheim
Data Visualizer
Data Analyst
Data Engineer
This CLI PostgreSQL tool is a command-line application developed in Python using Psycopg2, designed to streamline interactions with PostgreSQL databases. It offers a range of functionalities for managing and querying database tables, making it a valuable asset for developers and database administrators who prefer a terminal-based interface.
Database Interaction:
Tables: Fetch a list of all tables within the connected PostgreSQL database.
Fetch Records: Retrieve records and metadata from a specified table, with an optional limit on the number of records.
Backup: Perform backups of individual tables to safeguard your data.
Ease of Use:
Simple command-line interface with clear, straightforward commands for efficient database management.
Programming Language:
Python: Utilized for its ease of development and powerful libraries for database interaction.
Libraries:
Psycopg2: Provides a robust interface for connecting and executing queries on PostgreSQL databases.
Dotenv: Manages environment variables for secure configuration.
Tabulate: Formats the output for better readability in the terminal.
