Documentation

Connecting to Databases

The Database Client lets you connect to SQL and NoSQL databases, browse their structure, and execute queries. This feature is available only in the desktop application.

DatabaseSupported Types
SQLMySQL, PostgreSQL, SQLite
NoSQLMongoDB

Managing connections

Connections are stored in the database-connections folder within your current workspace. To create a new connection:

  1. Click the + button in the sidebar or within the Database view.
  2. Select the Database type.
  3. Enter the Host and Port.
  4. Set a Display name (defaults to host:port).
  5. Database name: Enter a specific database to connect to, or leave empty to list all available databases.
  6. Enter the Username and Password.
  7. Click Test connection to verify the configuration.
  8. Click Save connection.

!NOTE Passwords are not stored in your workspace files. They are securely saved in your operating system's keychain (Credential Manager on Windows, Keychain Access on macOS) and linked to the connection via a unique ID.

Browsing schemas

Use the Database view in the sidebar to explore your data hierarchy. You can expand connections to see:

  • SQL: Connection > Databases > Schemas > Tables.
  • NoSQL: Connection > Databases > Collections.

Clicking on a table or collection will automatically open a new tab to view its contents.

Executing queries

The query editor supports standard SQL for relational databases and BSON-style JSON queries for MongoDB.

  • Variables: Use {{variableName}} syntax to substitute environment variables into your queries.
  • Keyboard Shortcut: Press Ctrl + Enter to execute the current query.
  • Autocomplete: The editor provides suggestions for SQL keywords and table names based on the active connection.

Inspecting results

Results are displayed in either a Table or JSON view.

Table view

  • Sorting: Click column headers to sort the result set.
  • Cell Viewer: Double-click any cell to view its full content in a side panel. This is useful for large text blocks or JSON objects stored in columns.
  • Metrics: The row count and execution time are displayed in the results header.

JSON view

Switch to the JSON view to use the Data Inspector on the result set. This allows you to run JSONPath queries and search across the entire response body.