DolphinDB is a high-performance time-series database that integrates a powerful programming language and a real-time streaming data system to provide a one-stop solution for fast storage, retrieval, analysis and computing of large amounts of structured data. qStudio is a free SQL GUI, it allows running SQL scripts, easy browsing of tables, charting and exporting of results. It works on every operating system, with every database including TDEngine.


  • DolphinDB Syntax Highlighting
  • DolphinDb SQL Code Completion
  • Server Browser for visually viewing a servers objects
  • Charts for displaying your data
  • All with specific support for DolphinDB

Setting up a DolphinDB connection in qStudio

Start DolphinDB

  1. Download DolphinDB from the official website.
  2. Check dolphindb.cfg to see the setting for localSite=localhost:8848.
  3. Start dolphindb.exe
  4. Connecting to a Server

    When you first open qStudio it will look like the image below.

    1. Click on the menu options Server->Add Server or on the add server button on the toolbar.
    2. Server Type: DolphinDB
    3. Host:localhost
      Port: 8848
    4. Username: admin
      Password: 123456
    5. Click Add

    Add DolphinDB Connection

    Either when you add the connection or once you try to run code in the code editor, you will be asked to install the driver automatically. Say Yes.running

    Install JDBC Driver Prompt

    Sending Queries

    Copy paste the below code into the SQL editor. Then highlight the commands you want to run and press Ctrl + e to run that code. See Keyboard Shortcuts.

    Run highlighted text Ctrl + e
    Run Line Ctrl + Enter

    This will update your various results panels, result contains your table (excel export etc. supported), charts are generated based on your data and the console summarizes your recent commands

    Run DolphinDB Select

    The Server Tree

    Warning: DolphinDB driver only works with java 9+. If you attempt to run earlier java versions, it will not work.

    Well Done! You have now got qStudio querying your database successfully.

    We want to make qStudio the best SQL analysis tool. If you have any problems or want additional features, please post on our github repo.