English | Português (Brasil)
The SQL Server Management Studio experience, for PostgreSQL. A native Windows client with database diagrams, a visual query designer and context-aware IntelliSense, plus Object Explorer, F5 to run, execution plans, session monitoring and backup/restore, built for people who already think in SSMS.
Download v0.1.0-alpha.5 for Windows x64 · Graphical installer (EN/pt-BR) or portable ZIP, .NET runtime included · Works with PostgreSQL 16–18
Early pre-release. Querying, browsing and monitoring are the core of this alpha; administration and backup run through reviewable SQL and the official PostgreSQL tools. Full SSMS parity is not claimed. See known limits and release notes.
See your schema the way you see it in SSMS. Add tables and their related tables, drag one column onto another to create a foreign key, change columns and primary keys inside the diagram, and let Arrange Tables lay everything out. Every change to the database is shown as a SQL script for review first. Diagrams are saved on the server, in a small pgms schema that PGMS asks permission to create.
Build queries by clicking instead of typing. Query ▸ Design Query in Editor (Ctrl+Shift+Q) opens the statement under the cursor in synchronized Diagram, Criteria and SQL panes: tick columns, set filters and sort order, and joins come from your foreign keys. Change the type to Update, Delete, Insert or Make Table. It only writes SQL into your editor and never runs it. UNION and WITH open in the SQL pane only.
Press Ctrl+Space and get what fits that position. After FROM: tables, views and table functions, found by name across all your schemas. After JOIN: the whole join from your foreign keys, such as orders o ON o.customer_id = c.id. After an alias: its columns. Typing ignores accents, so usuar finds Usuários. Parameter Info, Quick Info and CTE columns are not available yet.
- Generate SQL with AI. Describe a query and review the SQL before it reaches the editor, using Anthropic, OpenAI or a local Ollama with your own key. Your request and the database structure go to the provider you configure; table data is never read or sent.
- Configure Server TLS. A guided setup that installs a certificate and turns on TLS, restoring the previous settings if it fails. Requires a superuser connection to a server running on Windows.
- Feels like SSMS. Object Explorer, query tabs with their own sessions, Results/Messages, F5 and the shortcuts you already use.
- Review before you apply. Administrative changes are shown as SQL first, so nothing touches the server without you reading it.
- Know what's running. Session and blocker monitor that distinguishes cancelling a query from terminating a session.
- Native and fast. C#/WPF on .NET 10, no browser and no JVM.
- Your drafts survive. Unsaved query tabs are checkpointed and recovered after a crash or forced close, encrypted per Windows user.
- SQL editor: highlighting, context-aware IntelliSense, find/replace, multiple tabs, save/load and encrypted draft recovery.
- Database diagrams, Table Designer, View Designer and Query Designer.
- Independent PostgreSQL sessions, execute/cancel, Results/Messages, result grids in pages of 100,000 rows (configurable), results to text or file, copy and CSV/JSON export.
- Object Explorer, inspection, graphical execution plans (estimated and actual) and session configuration.
- Reviewed SQL administration for supported databases, schemas, tables, columns, identity, indexes, constraints, sequences, roles and privileges.
- Session/blocker monitoring, with distinct query cancellation and session termination.
- Logical backup/restore through external PostgreSQL tools: custom, tar, SQL and directory formats, plus reviewed global operations.
Download the installer or the ZIP from the latest release, run it, then use Connect and New Query. Backup/restore needs the PostgreSQL client tools (pg_dump, pg_restore, psql) of the same major version as the server. Details: setup guide.
PGMS releases are not code-signed yet, so Windows may show "Windows protected your PC" the first time you run the installer or PGMS.exe. Choose More info and then Run anyway. Before doing so, confirm the download matches the checksums published with the release:
Get-FileHash .\PGMS-* -Algorithm SHA256Compare the hashes with SHA256SUMS.txt in the release. Starting with v0.1.0-alpha.2 the assets are built by the release workflow on GitHub Actions and carry a build provenance attestation, so you can also confirm that the ZIP or installer came from that workflow and this repository (requires the GitHub CLI):
gh attestation verify .\PGMS-0.1.0-alpha.5-Setup-x64.exe --repo leoars/PostgresManagementStudiov0.1.0-alpha.1 was built on the maintainer's machine and has checksums only. Code signing through the SignPath Foundation open source program is planned.
For development: Windows x64, PowerShell 7 and the .NET SDK selected by global.json (10.0.400, latest installed patch in that feature band). PostgreSQL 16–18 and matching-major tools are needed for database tests and backup/restore.
git clone https://github.com/leoars/PostgresManagementStudio.git
cd PostgresManagementStudio
./scripts/Build.ps1
dotnet run --project src/PGMS.DesktopThe self-contained portable package includes .NET/WPF, but no PostgreSQL server or tools. Local candidate ZIPs and acceptance artifacts are absent from a fresh clone. See setup and packaging.
| Topic | English | Português (Brasil) |
|---|---|---|
| Setup and packaging | Guide | Guia |
| Queries, administration, backup | User guide | Guia de uso |
| Build, tests, contributions | Development | Desenvolvimento |
| Structure | Architecture | Arquitetura |
| Evidence and limits | Validation | Validação |
| Attribution | Licensing | Licenças |
Documentation index. Public guides are maintained in both languages; the original internal development history is not included in this curated source repository. Bilingual documentation does not localize the application UI.
See CONTRIBUTING.md and the code of conduct. English and Brazilian Portuguese are welcome. Issue templates guide bug reports and feature requests; usage questions go to Discussions. Use synthetic data and remove credentials and personal information from reports. For vulnerabilities, follow SECURITY.md.
PGMS is created and maintained by Leonardo Santos. Its original code and documentation use Apache-2.0: free for personal and business use, keeping the copyright and the credits in NOTICE. Releases through 0.1.0-alpha.4 remain under MIT. Third-party components and the PostgreSQL elephant retain their own licenses and trademark terms; see third-party notices. PGMS is independent, without endorsement by Microsoft or the PostgreSQL project. SSMS is a reference, not a distributed dependency.