Sublime Forum

SQLTools. The SQL Swiss knife

#1

Some days ago I started this new project to save me time at work and home. This way SQLTools was born.

Features

  • View table schemas (CTRL+e, CTRL+d)
  • View Queries history (CTRL+e, CTRL+h)
  • Show table records
  • Auto complete (for PostgreSQL & MySQL. Looking for help with other SGDBs)
  • Run SQL Queries (CTRL+e, CTRL+e)
  • Formatting SQL Queries (CTRL+e, CTRL+b)
  • Threading Support (prevent ST lockups)
  • Query timeout (Kill thread if query takes too long)
  • Unescape chars for languages (PHP " is replace by ")
  • Save queries (CTRL+e, CTRL+q)
  • List and Run saved queries (CTRL+e, CTRL+a)
  • Remove saved queries (CTRL+e, CTRL+r)

Check out the project here:
http://mtxr.github.io/SQLTools

8 Likes

#2

Any plans to support ms sqlserver?

Robb

0 Likes

#3

Great plugin, works perfect! ( Using it with PostgreSQL )

0 Likes

#4

I just installed the package and I can’t seem to get the PostgreSQL connection to work. The connection selection looks like: DB: None, Connection: None@None:None

I am able to manually use the psql CLI through the Mac Terminal and connect successfully.

0 Likes

#5

how to start this plugin with mysql ?
please help me

0 Likes

#6
  1. Install SQLTools plugin
  2. Configure Connections file (sublime command ST: Setup Connection or look in menu Package Settings - SQLTools - Connections)
  3. Execute SQL or other SQLTools command using shortcuts or Commands (ST: Execute, ST: Table Description, etc)
0 Likes

#7

Hi, does the plugin work for MSSQL Server? If so, is there an example of connection configuration for this DBMS? Thanks!

0 Likes