mssql-cli vs pgcli

Our great sponsors

InfluxDB - Power Real-Time Data Analytics at Scale

WorkOS - The modern identity platform for B2B SaaS

SaaSHub - Software Alternatives and Reviews

Our great sponsors

mssql-cli		pgcli
	Project
1	Mentions	9
1,340	Stars	11,707
0.7%	Growth	1.0%
0.6	Activity	7.1
2 months ago	Latest Commit	6 days ago
Python	Language	Python
BSD 3-clause "New" or "Revised" License	License	BSD 3-clause "New" or "Revised" License

The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

mssql-cli

Posts with mentions or reviews of mssql-cli. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-03-23.

Has anyone used MSSQL with Flask or any other python framework?
2 projects | /r/SQLServer | 23 Mar 2021

I don't think this answers your question but here goes. I've used mssql-cli on a CentOS dev server at work pretty extensively and I haven't seen any performance issues with the exception of slow SQL passed to through to the DB.

pgcli

Posts with mentions or reviews of pgcli. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-04-25.

Postgres: ERROR: column d.adsrc does not exist
1 project | /r/PostgreSQL | 23 May 2022

Home: http://pgcli.com
5 Useful Database Command Line Tools
9 projects | dev.to | 25 Apr 2022
Visualize explain results from postgresql in pgcli
2 projects | dev.to | 5 Apr 2022

pip install git+https://github.com/dbcli/pgcli@main
14 Awesome CLI Tools for Modern Software Developers
13 projects | dev.to | 23 Mar 2022

pgcli is like DataGrip on your terminal.
Pipx: A python package consumption tool for CLI packages
12 projects | dev.to | 20 Mar 2022

If you want to know more about pgcli tool/package in Python, you can it's documentation webpage or the GitHub repository.
Pgcli – Postgres CLI with autocompletion and syntax highlighting
1 project | news.ycombinator.com | 13 Feb 2022
Advanced PostgreSQL/MySQL terminal clients
2 projects | /r/devops_tips | 3 Feb 2022
Commandline Database Clients with Autocompletion and Syntax Highlighting
2 projects | news.ycombinator.com | 18 Feb 2021

In what way did it blow up? You must have hit a bug, using .pg_service should work. Would you care to open an issue on https://github.com/dbcli/pgcli/issues or just dump the error message here so we can investigate?

What are some alternatives?

When comparing mssql-cli and pgcli you can also consider the following projects:

sqltoolsservice - SQL Tools API service that provides SQL Server data management capabilities.

httpie - 🥧 HTTPie CLI — modern, user-friendly command-line HTTP client for the API era. JSON support, colors, sessions, downloads, plugins & more.

pysonDB - A Simple , ☁️ Lightweight , 💪 Efficent JSON based database for 🐍 Python. PysonDB-V2 has been released ⬇️

cookiecutter - A cross-platform command-line utility that creates projects from cookiecutters (project templates), e.g. Python package projects, C projects.

data-profiling - a set of scripts to pull meta data and data profiling metrics from relational database systems

aws-cli - Universal Command Line Interface for Amazon Web Services

SQLMap - Automatic SQL injection and database takeover tool

HTTP Prompt - An interactive command-line HTTP and API testing client built on top of HTTPie featuring autocomplete, syntax highlighting, and more. https://twitter.com/httpie

TinyDB - TinyDB is a lightweight document oriented database optimized for your happiness :)

percol - adds flavor of interactive filtering to the traditional pipe concept of UNIX shell

Python Fire - Python Fire is a library for automatically generating command line interfaces (CLIs) from absolutely any Python object.

autopexpect - autoexpect for pexpect