I'd like to ask how everyone quickly accesses the many PostgreSQL instances deployed in Kubernetes. If you use development tools like DataGrip, you have to go through a rather complex configuration process. But if you're frequently using these instances, such tools can still be quite convenient.
So, I tried vibe-coding a project p6s that mimics the way k9s works—allowing quick access to PostgreSQL instances via a TUI (terminal user interface). It also comes with some basic built-in queries, such as active connection count and table storage information for databases.
Right now, it’s still quite basic. I’d like to expand it to support more database types—such as MySQL, ClickHouse, and others—directly. I’d really appreciate any suggestions or ideas you might have!
Tostino•4mo ago
When I need to access an instance I do a local port forward for that instance using kubectl and connect to it with pgadmin like any other database. If I need to access another instance, I close that port forward and open another to the instance I want to connect to. If I need multiple at once for some reason I could choose different local ports and have them pre-configured in pgadmin...but I don't generally need that.
xiangyufan723•5mo ago
So, I tried vibe-coding a project p6s that mimics the way k9s works—allowing quick access to PostgreSQL instances via a TUI (terminal user interface). It also comes with some basic built-in queries, such as active connection count and table storage information for databases.
Right now, it’s still quite basic. I’d like to expand it to support more database types—such as MySQL, ClickHouse, and others—directly. I’d really appreciate any suggestions or ideas you might have!
Tostino•4mo ago