/sublime-sqlexec

A Plugin for running SQL commands in Sublime Text

Primary LanguagePython

sublime-sqlexec

A Plugin for running SQL commands in Sublime Text. Compatibility: MySQL, PostgreSQL.

Installation

Download the Zip file, extract it to your Sublime Text packages directory, and rename it to SQLExec

Some directories have to be defined in the PATH environment variable, according to the SGBD that you want to use: "mysql" executable for MySQL, "pgsql" executable for PostgreSQL, or "sqlplus" executable for Oracle ( Not tested )

Sample configuration file

{
    "connections": {
        "Connection 1": {
            "type"    : "mysql",
            "host"    : "127.0.0.1",
            "port"    : 3306,
            "username": "user",
            "password": "password",
            "database": "dbname"
        },
        "Connection 2": {
            "type"    : "pgsql",
            "host"    : "psql.server.fr",
            "username": "anotheruser",
            "password": "password",
            "database": "dbname"
        },
    }
}

Usage

Default shortcuts are :

  • ctrl+alt+e: swhitch connection
  • ctrl+e ctrl+e: execute selected query
  • ctrl+e ctrl+q: type a query
  • ctrl+e ctrl+s: show tables records
  • ctrl+e ctrl+d: desc table