The first time I ran pgcli against a fresh database, it felt like a live wire in my hands. Fast, smart, and precise. But the real power came when I tied it to user provisioning—no more guesswork, no more stale credentials, no more delays.
User provisioning with pgcli is about control. You create, alter, and drop roles with speed. You switch between databases instantly. You see the results in real time, with intelligent auto-complete, syntax highlighting, and clean formatting that makes every command clear. It turns PostgreSQL role management from a tedious list of commands into a fluid workflow.
A common pain is keeping database users aligned with application access rules. Whether you’re onboarding a developer, spinning up a temporary analyst account, or removing stale logins, pgcli lets you do it in seconds. You can connect over SSL, run CREATE ROLE, grant privileges, test queries, and revoke access—all in one continuous session. Every keystroke matters and every delay vanishes.
To set it up, install pgcli and connect it to your PostgreSQL instance:
pip install pgcli
pgcli -h <hostname> -U <username> -d <database>
Once inside, you can run:
CREATE ROLE new_user LOGIN PASSWORD 'secure_password';
GRANT CONNECT ON DATABASE mydb TO new_user;
GRANT USAGE ON SCHEMA public TO new_user;
GRANT SELECT, INSERT, UPDATE ON ALL TABLES IN SCHEMA public TO new_user;
These are not just steps—they’re the building blocks of secure, efficient user provisioning. pgcli’s smart features make it easy to spot errors before they bite. You see the structure. You feel the flow.
Security teams love it because you can enforce least privilege without slowing down development. Operations teams love it because they can scale databases and accounts without bloated automation scripts. And engineering teams love it because it keeps context in the terminal, without breaking focus.
If you’ve been fighting slow admin tools or awkward web consoles, this is your upgrade path. Tie pgcli user provisioning into your workflow and you’ll never look back.
With Hoop.dev, you can see all of this in action—live, in minutes. Connect your database, run pgcli, and watch user provisioning become instant, clear, and repeatable. You don’t need a long setup or complex integrations. You just plug it in and go.
The fastest way to understand the power here is to try it. See what it feels like when user provisioning happens at the speed of thought.