Postgres Language Server

A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.

0.10.0

This release fixes a deadlock that w as introduced earlier and adds support for named parameters in the lexer.

🚀 Features

• Add support for named params (#458)

🐛 Bug Fixes

• Revoke split (#459)
• Deadlock (#460)
• Syntax error regression (#461)

⚙️ Miscellaneous Tasks

• Expose schema_cache & file_context in lint rules (#449)

Contributors

@juleswritescode
@psteinroe

Contributors

Postgres Language Server

A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.

This release comes with a few very important under-the-hood refactors that remove the reason why the server crashed sometimes entirely, and unblocks us to work on more advanced features!

Please open an issue if the server still crashes on you.

we also shipped a few features:

• linter suppression

-- pgt-ignore lint/safety/banDropTabledroptable users;

• plpgsql syntax errors

0.9.0

🚀 Features

• Customise severity per rule (#430)
• Linter suppressions (#440)
• Show plpgsql syntax errors (#452)

🐛 Bug Fixes

• (splitter) Do update in INSERT INTO (#436)
• (analyser) Recognize disabled rules (#438)

🚜 Refactor

• Custom lexer (#437)
• Drop change.rs (#447)
• Simplify caches (#448)

📚 Documentation

• Rule suppressions (#443)

⚙️ Miscellaneous Tasks

• (docs) Fix schema links (#451)
• Add Nix development environment (#441)
• Fix doc command (#450)
• Update git cliff version

Contributors

@juleswritescode
@psteinroe

Contributors

Postgres Language Server

A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.

0.8.1

🐛 Bug Fixes

• Batched changes (#428)

Contributors

• @psteinroe

Contributors

Postgres Language Server

A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.

0.8.0

🚀 Features

• Workspace support (#408)
• Versioned docs (#414)
• (schema-cache) Include procedures & aggregates, fix query (#424)
• (completions) Complete (materialized) views (#409)
• (completions) Alter/drop/rename column statements (#421)
• (completions) Complete in (simple) function bodies (#426)
• (completions) Complete roles (#410)
• (completions) Complete in WITH CHECK and USING clauses (#422)

🐛 Bug Fixes

• (docs) Make latest default after next release (#420)
• (completions) Convert SQL to lowercase (#416)
• (splitter) Split grant stmts (#425)
• Broken text after receiving batched changes (#413)
• Release pipeline points at correct schema.json (#427)

🚜 Refactor

• (test_db) Use sqlx::test instead (#411)

Contributors

• @juleswritescode
• @psteinroe

Contributors

Postgres Language Server

A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.

0.7.0

🚀 Features

• (completions) Respect table aliases, complete in JOINs (#388)
• (completions) Fill in alias for columns in join clauses (#392)
• Allow configuration through workspace/didChangeConfiguration (#316)
• (completions) Lower priority of already mentioned columns in SELECT (#399)
• (completions) Complete policies (#397)
• (completions) Nicer function completions (#401)
• (completions) Show data type for columns (#402)
• (completions) Complete insert, drop/alter table, ignore many situations, improve WHERE (#400)

🐛 Bug Fixes

• (splitter) Allow newlines after commas (#380)
• Properly parse trigger with instead of (#383)
• (completions) Complete right columns right after JOIN ON (#390)
• Properly handle multiple changes at once (#389)
• (completions) Use fuzzy matching for user input (#393)
• Do not complete right after asterisk (#394)
• Sql fn params (#366)
• Nullabe column query (#406)

📚 Documentation

• Mention Emacs client (#378)

⚙️ Miscellaneous Tasks

• (schema_cache) Query policies (#379)
• (completions) Add tree sitter query for table aliases
• Add contributors to changelog (#387)
• (schema_cache) Add query for triggers (#398)
• (schema_cache) Add query for roles (#404)

Contributors

• @willruggiano made their first contribution in#316 🎉
• @jcs090218 made their first contribution in#378 🎉
• @juleswritescode
• @psteinroe

Contributors

Postgres Language Server

A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.

0.6.1

🐛 Bug Fixes

• Does not split statements at aWITH TIMEZONE anymore
• Does not try to connect topostgresql://postgres:postgres@127.0.0.1:5432/postgres if nodb section is configured inpostgrestools.jsonc anymore

Postgres Language Server

A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.

0.6.0

🚀 Features

• (completions) Filter out irrelevant completion items: For example, it does not make sense to suggest columns in a FROM clause.

• (completions) Insert schema name when selecting non-public tables: If you accept a suggestion from another schema thenpublic, the schema name will be added into the editor.

🐛 Bug Fixes

• (completions):, does not trigger suggestions anymore (' ' still does)
• (completions): Fixed a bug where'.' led to invalid completions.
• (completions): Completion items are now correctly sorted in the editor.

Postgres Language Server

A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.

0.5.0

🚀 Features

• Autocomplete schemas (#340)

🐛 Bug Fixes

• Comments only (#337)
• Release changelog (#338)
• Dont point to 404 in config schema (#339)
• Plpglsql cmds (#336)
• Typing comments (#347)
• Report db connection errors (#348)
• Split grant stmt properly (#350)
• Extract sql fn body properly (#346)

⚙️ Miscellaneous Tasks

• Add double newline comment (#341)
• Ensure auto fixes are applied (#349)
• Test fn body content (#351)

postgrestools0.3.1

This release fixes a few minor bugs and enables building without an active db connection - a prerequisite for homebrew.

🐛 Bug Fixes

• Enable sqlx offline mode (#297)
• Support non timestamp but numeric migrations (#301)
• Nested () and with check (#307)
• Log more (#309)

Changelog

This release fixes all bugs reported by early users since the public announcement. And includes a new feature!

You can now execute a statement directly within your IDE using Code Actions. This is very useful if you want to quickly iterate on a function.

To enable the feature, you must first set adb.allowStatementExecutionAgainst property in yourpostgrestools.jsonc. It should be an array of<hostGlobPattern>/<databaseNameGlobPatterns> strings.
Seedocs for examples.

🚀 Features

• Execute stmt under cursor (#257)

🐛 Bug Fixes

• Cte (#263)
• Typo on docs/index.md (#283)
• Tree-sitter edit_from_change crash (#273)
• View with options (#288)
• Version (#289)
• Run ci for workflows (#290)
• Use byte indices (#286)
• Execute statement reliable (#291)

🚜 Refactor

• Move lsp converters to lsp crate (#275)
• Move workspace features to own mod (#276)
• Move get_cursor_position to adapters (#278)

⚙️ Miscellaneous Tasks

• Fix bug in codegen (#256)
• Add show-logs justfile cmd (#258)
• Add install docs (#259)
• Add test (#260)
• Add demo media (#264)
• Cleancargo check andcargo clippy (#277)
• Only deploy docs on release (#285)
• Upgrade pg_query and both submodules (#294)
• Update submodules (#295)
• Improve logs (#266)