KingbaseES Database Management in VS Code

KingbaseES is a commercial database built on PostgreSQL. Because it speaks the PostgreSQL wire protocol and exposes the PostgreSQL system catalogs, DBCode manages it through its PostgreSQL support. DBCode automatically detects the database’s compatibility mode (PostgreSQL or Oracle) on connect, so both modes work without any extra configuration.

Connecting

To connect to KingbaseES, follow these general steps:

1. Open the DBCode Extension: Launch Visual Studio Code and open the DBCode extension.
2. Add a New Connection: Click on the “Add Connection” icon.
3. Complete new connection form: Choose KingbaseES as the type, then enter the host, port (54321 by default), database, and credentials.
4. Connect: Click save to connect to your KingbaseES database.
5. Start Managing Your Databases: Once connected, you can browse schemas, run queries, and edit data directly from Visual Studio Code.

For detailed instructions on connecting, refer to the Connect article.

Kerberos / GSSAPI Authentication

DBCode exposes Integrated (Kerberos) for KingbaseES connections when the server is configured to accept compatible GSSAPI or SSPI authentication.

• Select Integrated (Kerberos) and enter the KingbaseES username that the Kerberos identity maps to.
• On Windows, DBCode uses the current signed-in identity. On macOS and Linux, it uses an existing Kerberos ticket cache.
• Integrated authentication requires a host/TCP connection. DBCode does not accept or manage keytabs.
• The default Kerberos Service Name is kingbase. Change it only when the server administrator registered another service name.

For more information about KingbaseES, check out KingbaseES.