ctrl+shift+p filters: :st2 :st3 :win :osx :linux


by Sequoia Studios ST2/ST3 Missing

Commercial Database Client. Connect, Configure and Query Databases Directly From Sublime



  • Total 657
  • Win 287
  • OS X 233
  • Linux 137
Oct 21 Oct 20 Oct 19 Oct 18 Oct 17 Oct 16 Oct 15 Oct 14 Oct 13 Oct 12 Oct 11 Oct 10 Oct 9 Oct 8 Oct 7 Oct 6 Oct 5 Oct 4 Oct 3 Oct 2 Oct 1 Sep 30 Sep 29 Sep 28 Sep 27 Sep 26 Sep 25 Sep 24 Sep 23 Sep 22 Sep 21 Sep 20 Sep 19 Sep 18 Sep 17 Sep 16 Sep 15 Sep 14 Sep 13 Sep 12 Sep 11 Sep 10 Sep 9 Sep 8 Sep 7
Windows 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
OS X 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Linux 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0



DB1: A Sublime Text Database Client

DB1 allows you to execute queries against multiple database types (currently PostgreSQL, MySQL, SQLite, and MariaDB) from inside Sublime without installing any dependencies (a local database installation is not required).

If you'd like to read the full documentation for DB1, you can see it here

As an introduction to DB1 (after installing), we'd highly suggest the Quick Start guide.



If Package Control is already installed:

  1. Open the Sublime Text command palette ("Tools" > "Command Palette")
  2. Enter Package Control: Install Package
  3. Enter DB1

Congratulations! DB1 will now be installed. If you are not greeted with the DB1 installation message from Package Control, please restart Sublime Text.

If Package Control is not already installed, please follow the instructions for installation, and then follow the above instructions.

Quick Start

The first step to getting started is making sure that DB1 is installed.

Once that's finished, the first big command is DB1: Connect to a Database. DB1: Connect to a Database initiates a connection for a single view in Sublime Text. This means that there's a one-to-one relationship of connections to views. Each connection is then tied to the database it's connected to, such that in view #1 you can execute queries on database 'A', and in View #2 you can execute queries on database 'B'.

When using the DB1: Connect to a Database you'll need to know the username, host, port (if it's not the default) and password of the database you're connecting to. In cases like PostgreSQL authentication (where authentication is trust based) a password is not required.

To help streamline workflow, if there is not a connection active in the view, then running one of the DB1: Execute ... SQL will initiate the connection process before the query is then run.

Once you're connected, DB1 will prompt you with a list of databases to choose from. The database you select is the one you can now execute queries against. You can then change databases using the DB1: Change Database command.

Now that we're ready to run some queries, DB1 supports a couple different workflows.

  1. The Results Window Workflow

The Results Window workflow allows for you to have a continuously open window to display query results. This contrasts the disposability of the Quick Query window, where results are lost when the window is closed.

Results Window

As you can see above, we are free to execute queries in the left view, while the results are displayed in the Results Window on the right.

A quick note: By default, when executing queries to the Results Window, after the query execution, the focus is changed to the Results Window. This can be annoying to some as you then have to reselect the query view on the left to write new queries. However, you can change functionality of it using the "focus_results_window_on_execution" setting to leave the focus on the execution view.

In addition to the above setting, by default the contents of Results Window is deleted with every query, but that setting can be changed to either "results_window_append_style": "prepend" or "results_window_append_style": "append" the prepend or append the results.

This workflow tends to work really well if you'd like to be able to interact with results, as you can do things like search for text in the Results Window.

  1. The Quick Query view. The Quick Query view outputs the results of a query to a disposable (you can't save it, and when it's gone, you can't recover the contents) output view at the bottom of a sublime window.

Quick Query view

Much like the Results Window, many aspects of the Quick Query view are fully customizable.

For more information about the DB1 Settings and commands please see the full documentation

Reporting Issues and Feature Requests

Please report all issues and feedback to the DB1 Issue and Request Tracker. All issues will be posted and followed there. In the event that Github is unavailable or extremely inconvenient, please email support@sequoiastudios.io

In addition to issues and feature requests, the documentation file used here is also hosted in that repository so as to track changes.



  • None.
Bug Fixes:
  • Removed Ubuntu dependency on Libpython that caused DB1 to not load on x64_86 Linux.


  • You can now specify ports using user@host:port syntax.
  • Postgresql 8.1 and early have increased performance.
  • You can now customize all aspects of a connection in the “stored_connections” setting.
Bug Fixes:
  • Fixed a bug causing issues with older versions of postgresql.
  • Fixed a bug that caused DB1 to sometimes ignore ports that were manually changed.


Feature Additions:
  • You can now connect to MariaDB and local SQLite databases through DB1.
  • Improved settings management and error correcting.
Bug Fixes:
  • Fixed 'null' port storage for some databases using the default port.
  • Fixed result window being reopened if the results window was in a separate window pane.
  • Fixed some connection timeout issues.