/vscode-sqltools

SQLTools for VSCode

Primary LanguageTypeScriptGNU General Public License v3.0GPL-3.0

SQLTools for VSCode

Build Status Paypal Donate

Your swiss knife SQL for VSCode.

(The project is currently under development.)

Project website: https://github.com/mtxr/vscode-sqltools

If you are looking for Sublime Text version go to http://mtxr.github.io/SQLTools/.

Donate

SQLTools was developed with ♥ to save us time during our programming journey. But It also takes me time and efforts to develop SQLTools.

SQLTools will save you (for sure) a lot of time and help you to increase your productivity so, I hope you can donate and help SQLTools to become more awesome than ever.

Paypal Donate

Features

  • SQL Format (Beautifier)
    • Win/Linux: ctrl+e ctrl+b
    • OSX: cmd+e cmd+b
    • or using the standard VSCode Format Document/selection
  • Bookmark query
    • Win/Linux: ctrl+e ctrl+q
    • OSX: cmd+e q
  • Delete Bookmarked query
    • Win/Linux: ctrl+e ctrl+r
    • OSX: cmd+e cmd+r
  • Edit Bookmarked query
  • Auto complete for Table names and columns

static/autocomplete.png

  • Sidebar database explorer

static/sidebar.png

Docs

Setup your first connection using this guide: Connections

You can read the entire docs in the SQLTools Wiki

To-do

  • Allow switch databases
  • Create connection profile tour
  • Show explain plan for queries
  • SQLite Support
  • Show query execution messages
  • Sidebar explorer with Table Description, query generator, table records
  • Auto complete for columns and tables
  • List and Run bookmarked queries
  • Run SQL Queries
  • Show table records
  • View Queries history
  • View table schemas
  • MySQL/MariaDB Support
  • MsSQL Support
  • PostgreSQL Support

Migrating from v0.0*.* to v0.1*.* or newer

Some settings were changed to keep SQLTools naming standards.

  • sqltools.format.indent_size was renamed to sqltools.format.indentSize
  • sqltools.format.show_statusbar was renamed to sqltools.format.showStatusbar
  • sqltools.format.log_level was renamed to sqltools.format.logLevel
  • sqltools.format.query_timeout was renamed to sqltools.format.queryTimeout
  • sqltools.format.history_size was renamed to sqltools.format.historySize
  • sqltools.format.show_result_on_tab was renamed to sqltools.format.showResultOnTab
  • sqltools.format.clear_output was renamed to sqltools.format.clearOutput

Known Issues

None for now.