The PostgreSQL Tools Service (pgtoolsservice, or PGTS) is an application that provides core functionality for various PostgreSQL Server tools.
- Connection management
- Language Service support using VS Code protocol
- Query execution and resultset management
It is based on an early version of Microsoft SQL Tools Service, with some functionality coming from pgAdmin and pgcli.
There are two servers in PGTS: A RPC server that reads and writes JSON-RPC messages from stdin/stdout, and a web server that reads and writes JSON-RPC messages over HTTP using web sockets. The web server is used to provide a REST API for the RPC server. Both servers use messaging defined by the Language Server Protocol (LSP).
The project is named pgtoolsservice, but there is the name ossdbtoolsservice in some places. This reflects a refactor that was done years ago to make the project more generic and support other databases.
However, that refactor was never completed, and the project is still PostgreSQL specific. The name ossdbtoolsservice will be removed in a future release.
Support for this extension is provided on our GitHub Issue Tracker. You can submit a bug report, a feature suggestion or participate in discussions.
See the developer documentation for details on how to contribute to this extension.
This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.
The Microsoft Enterprise and Developer Privacy Statement describes the privacy statement of this software.
This extension is licensed under the MIT License. Please see the third-party notices file for additional copyright notices and license terms applicable to portions of the software.
See the DEVELOPING.md for details on how to develop this project.