Kdb+ SQL IDE

Kdb+ is an in-memory column-oriented database based on the concept of ordered lists. It is popular within finance for storing market/tick data. qStudio is a free SQL IDE, it allows running SQL scripts, easy browsing of tables, charting and exporting of results. It works on every operating system, with every database including kdb+.

Setting up a kdb+ connection in qStudio

Start kdb+

See also our getting started with kdb+ tutorial

1. Download kdb+ from the official website.
2. Start kdb+ with "-p 5000" to start it on port 5000.
KDB+ 4.0 2020.06.01 Copyright (C) 1993-2020 Kx Systems m64/ 12()core 65536MB sjt mackenzie.local 127.0.0.1 EXPIRE… q)

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: kdb+
3. Host:localhost
   Port: 5000
4. Click Add


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.

Command	Shortcut
Run highlighted text	Ctrl + e
Run Line	Ctrl + Enter

//### Example Time Series Charts ([] dt:2013.01.01+til 21; cosineWave:cos a; sineWave:sin a:0.6*til 21) ([] time:10:00t+60000*til 99; Position:0.4*a-mod[a;8]; Cost:a:100*sin 0.015*til 99) //### Example Line / Bar / Area Chart / Multiple Series with Time X-Axis ([Month:2000.01m + til 12] Costs:30.0 40.0 45.0 55.0 58.0 63.0 55.0 65.0 78.0 80.0 75.0 90.0 ; Sales:10.0 12.0 14.0 18.0 26.0 42.0 74.0 90.0 110.0 130.0 155.0 167.0 )

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



The Server Tree

The server tree populates and is fully complete and customized for kdb+.

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.