Skip to content

PGMS 0.1.0-alpha.6

Pre-release
Pre-release

Choose a tag to compare

View all tags
@github-actions github-actions released this 13 Nov 11:18
v0.1.0-alpha.6
205db66
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

PGMS alpha.6: database diagrams that AI agents can read (indexes, descriptions and Export for AI), Query History, execution plan warnings with missing index suggestions, Script as in Object Explorer, and AI-assisted SQL on large databases.

English. Native Windows PostgreSQL client with the SSMS workflow. What is new:

  • Diagrams: each table shows its indexes (GIN, GiST, BRIN, operator classes such as gin_trgm_ops) and warns about foreign keys without an index. Tables, columns and relationships can have descriptions, stored as COMMENT ON. Export for AI… writes the diagram as Markdown for an AI agent; the optional pgms.diagram_markdown(name) function returns the same text inside the database.
  • Query History (Ctrl+Alt+H): what you run is kept on your computer, encrypted for your Windows user, one row per distinct query.
  • Execution plans: operators that discard many rows are flagged, and Missing Index Details… opens a commented CREATE INDEX checked against the catalog. Nothing runs by itself.
  • Script as in Object Explorer, Take Offline/Bring Online, and the operation windows opened from an object now follow that object.
  • Generate SQL with AI on large databases: a configurable context limit, with the provider choosing the relevant tables by name first.

Português. Cliente PostgreSQL nativo para Windows, com a experiência do SSMS. Novidades:

  • Diagramas: cada tabela mostra os índices (GIN, GiST, BRIN, classes de operadores como gin_trgm_ops) e avisa sobre chaves estrangeiras sem índice. Tabelas, colunas e relações podem ter descrições, gravadas como COMMENT ON. Export for AI… gera o diagrama em Markdown para um agente de IA; a função opcional pgms.diagram_markdown(nome) devolve o mesmo texto dentro do banco.
  • Query History (Ctrl+Alt+H): o que você executa fica no seu computador, criptografado para o seu usuário do Windows, uma linha por consulta distinta.
  • Planos de execução: operadores que descartam muitas linhas são marcados, e Missing Index Details… abre um CREATE INDEX comentado e conferido no catálogo. Nada é executado sozinho.
  • Script as no Object Explorer, Take Offline/Bring Online, e as janelas de operação abertas de um objeto passam a seguir esse objeto.
  • Gerar SQL com IA em bancos grandes: limite de contexto configurável, e o provedor primeiro escolhe as tabelas relevantes pelos nomes.

This is an alpha for evaluation with test data; full SSMS parity is not claimed. / É uma alpha para avaliação com dados de teste; não há paridade completa com o SSMS.

Full notes / Notas completas: RELEASE-NOTES.md (English) and RELEASE-NOTES.pt-BR.md (Português do Brasil), attached below.

Verify / Verificar: binaries and installer are not code-signed; Windows SmartScreen may warn. Check SHA256SUMS.txt and the build provenance attestation (gh attestation verify <file> --repo leoars/PostgresManagementStudio).

Built by GitHub Actions run https://github.com/leoars/PostgresManagementStudio/actions/runs/43360632650 from commit 205db66.

Assets 8
Loading