SQLTools.sublime-settings

// NOTE: it is strongly advised to override
// only those settings that you wish to change
// in your Users/SQLTools.sublime-settings
{
    "debug"                 : true,
    "thread_timeout"        : 15,     // query timeout in seconds
    "history_size"          : 100,
    "show_result_on_window" : false,
    "clear_output"          : true,
    "safe_limit"            : false,
    "expand_to_paragraph"   : false,
    "use_streams"           : false, // use streams for results
    /**
     * The list of syntax selectors for which the plugin autocompletion will be active.
     * An empty list means autocompletion always active.
     */
    "selectors": ["source.sql", "source.pgsql", "source.plpgsql.postgres", "source.plsql.oracle", "source.tsql"],
    /**
     * Possible values for autocompletion: "basic", "smart", true ("smart"),
     *                                      or false (disable)
     * Completion keywords case is controlled by format.keyword_case (see below)
     */
    "autocompletion": "smart",
    /**
     * Possible values for show_query: "top", "bottom", true ("top"), or false (disable)
     * When using regular output, this will determine where query details is displayed.
     * In stream output mode, any option that isn't false will print query details at
     * the bottom of result.
     */
    "show_query": false,
    /**
     * If DB cli binary is not in PATH, set the full path in "cli" section.
     * Note: forward slashes ("/") should be used in path. Example:
     *  "mysql"   : "c:/Program Files/MySQL/MySQL Server 5.7/bin/mysql.exe"
     */
    "cli" : {
        "mysql"   : "mysql",
        "pgsql"   : "psql",
        "oracle"  : "sqlplus",
        "mssql"   : "sqlcmd",
        "vertica" : "vsql",
        "sqsh"    : "sqsh",
        "firebird": "isql",
        "sqlite"  : "sqlite3"
    },
    "show_records": {
        "limit": 50
    },
    "format" : {
        "keyword_case"    : "upper",
        "identifier_case" : null,
        "strip_comments"  : false,
        "indent_tabs"     : false,
        "indent_width"    : 4,
        "reindent"        : true
    },
    "unescape_quotes" : [
        "php"
    ],
    /**
     * Client options for you RDBMS.
     * In this file, the section cli has the names you can use here. Eg: "pgsql": "psql"
     * So here, you must have "psql with the same sections listed bellow (options, before, args and queries)"
     *
     * Avoid changing the brackets content in "args"
     */
    "cli_options": {
        "pgsql": {
            "options": ["--no-password"],
            "before": [],
            "args": "-h {host} -p {port} -U {username} -d {database}",
            "env_optional": {
                "PGPASSWORD": "{password}"
            },
            "queries": {
                "desc" : {
                    "query": "select '|' || quote_ident(table_schema)||'.'||quote_ident(table_name) ||'|' as tblname from information_schema.tables where table_schema not in ('pg_catalog', 'information_schema') order by table_schema = current_schema() desc, table_schema, table_name",
                    "options": ["--tuples-only", "--no-psqlrc"]
                },
                "desc table": {
                    "query": "\\d+ %s",
                    "options": ["--no-password"]
                },
                "show records": {
                    "query": "select * from {0} limit {1}",
                    "options": ["--no-password"]
                },
                "columns": {
                    "query": "select '|' || quote_ident(table_name) || '.' || quote_ident(column_name) || '|' from information_schema.columns where table_schema not in ('pg_catalog', 'information_schema') order by table_name, ordinal_position",
                    "options": ["--no-password", "--tuples-only", "--no-psqlrc"]
                },
                "functions": {
                    "query": "select '|' || quote_ident(n.nspname)||'.'||quote_ident(f.proname) || '(' || pg_get_function_identity_arguments(f.oid) || ')' || '|' as funname from pg_catalog.pg_proc as f inner join pg_catalog.pg_namespace as n on n.oid = f.pronamespace where f.proisagg = false and n.nspname not in ('pg_catalog', 'information_schema')",
                    "options": ["--no-password", "--tuples-only", "--no-psqlrc"]
                },
                "desc function": {
                    "query": "\\sf %s",
                    "options": ["--no-password"]
                },
                "explain plan": {
                    "query": "explain {0};",
                    "options": ["--no-password"]
                }
            }
        },
        "oracle": {
            "options": ["-S"],
            "before": [
                "SET AUTO           OFF",
                "SET COLSEP         '|'",
                "SET FEED           ON",
                "SET FEEDBACK       ON",
                "SET HEADING        ON",
                "SET LINESIZE       32767",
                "SET LONG           100",
                "SET NULL           @",
                "SET PAGESIZE       0 EMBEDDED ON",
                "SET SERVEROUTPUT   ON",
                "SET SQLBLANKLINES  ON",
                "SET SQLPROMPT      ''",
                "SET TAB            OFF",
                "SET TI             ON",
                "SET TIMI           OFF",
                "SET TRIMSPOOL      OFF",
                "SET UND            '-'",
                "SET VERIFY         OFF ",
                "SET WRAP           OFF"
            ],
            "args": "{username}/{password}@\"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST={host})(PORT={port})))(CONNECT_DATA=(SERVICE_NAME={service})))\"",
            "queries": {
                "desc" : {
                    "query": "select concat(concat(concat(concat('|', owner), '.'), table_name), '|') as tbls from all_tables UNION ALL select concat(concat(concat(concat('|', owner), '.'), view_name), '|') as tbls from all_views;",
                    "options": ["-S"]
                },
                "columns": {
                    "query": "SELECT concat(concat(concat(concat('|', c.table_name), '.'), c.column_name), '|') AS cols FROM all_tab_columns c INNER JOIN all_tables t ON c.owner = t.owner AND c.table_name = t.table_name UNION ALL SELECT concat(concat(concat(concat('|', c.table_name), '.'), c.column_name), '|') AS cols FROM all_tab_columns c INNER JOIN all_views t ON c.owner = t.owner AND c.table_name = t.view_name;",
                    "options": ["-S"]
                },
                "desc table": {
                    "query": "desc %s;",
                    "options": ["-S"]
                },
                "show records": {
                    "query": "select * from {0} WHERE ROWNUM <= {1};",
                    "options": ["-S"]
                },
                "explain plan": {
                    "query": "explain plan for {0};\nselect plan_table_output from table(dbms_xplan.display());",
                    "options": ["-S"]
                }
            }
        },
        "mysql": {
            "options": ["-f", "--table", "--default-character-set=utf8"],
            "before": [],
            "args": "-h{host} -P{port} -u\"{username}\" -D\"{database}\"",
            "args_optional": ["--login-path=\"{login-path}\"", "--defaults-extra-file=\"{defaults-extra-file}\"", "-p\"{password}\""],
            "queries": {
                "desc" : {
                    "query": "select concat('|', case when table_schema REGEXP '[^0-9a-zA-Z$_]' then concat('`',table_schema,'`') else table_schema end, '.', case when table_name REGEXP '[^0-9a-zA-Z$_]' then concat('`',table_name,'`') else table_name end, '|') from information_schema.tables where table_schema = database() order by table_name;",
                    "options": ["-f", "--silent", "--raw", "--default-character-set=utf8"]
                },
                "desc table": {
                    "query": "desc %s",
                    "options": ["-f", "--table", "--default-character-set=utf8"]
                },
                "show records": {
                    "query": "select * from {0} limit {1}",
                    "options": ["-f", "--table", "--default-character-set=utf8"]
                },
                "columns": {
                    "query": "select concat('|',  case when table_name REGEXP '[^0-9a-zA-Z$_]' then concat('`',table_name,'`') else table_name end, '.', case when column_name REGEXP '[^0-9a-zA-Z$_]' then concat('`',column_name,'`') else column_name end, '|') from information_schema.columns where table_schema = database() order by table_name, ordinal_position;",
                    "options": ["-f", "--silent", "--raw", "--default-character-set=utf8"]
                },
                "functions": {
                    "query": "select concat('|', case when routine_schema REGEXP '[^0-9a-zA-Z$_]' then concat('`',routine_schema,'`') else routine_schema end, '.', case when routine_name REGEXP '[^0-9a-zA-Z$_]' then concat('`',routine_name,'`') else routine_name end, '()', '|') from information_schema.routines where routine_schema = database();",
                    "options": ["-f", "--silent", "--raw", "--default-character-set=utf8"]
                },
                "desc function": {
                    "query": "select routine_definition from information_schema.routines where concat(case when routine_schema REGEXP '[^0-9a-zA-Z$_]' then concat('`',routine_schema,'`') else routine_schema end, '.', case when routine_name REGEXP '[^0-9a-zA-Z$_]' then concat('`',routine_name,'`') else routine_name end) = '%s';",
                    "options": ["-f", "--silent", "--raw", "--default-character-set=utf8"]
                },
                "explain plan": {
                    "query": "explain {0};",
                    "options": ["-f", "--table", "--default-character-set=utf8"]
                }
            }
        },
        "mssql": {
            "options": [],
            "before": [],
            "args": "-d \"{database}\"",
            "args_optional": ["-S \"{host},{port}\"", "-S \"{host}\\{instance}\"", "-U \"{username}\"", "-P \"{password}\""],
            "queries": {
                "desc": {
                    "query": "set nocount on; select concat(table_schema, '.', table_name) from information_schema.tables order by table_name;",
                    "options": ["-h", "-1"]
                },
                "columns": {
                    "query": "set nocount on; select concat(table_name, '.', column_name) from information_schema.columns order by table_name, ordinal_position;",
                    "options": ["-h", "-1"]
                },
                "desc table": {
                    "query": "exec sp_help \"%s\";",
                    "options": []
                },
                "show records": {
                    "query": "select top {1} * from {0};",
                    "options": []
                }
            }
        },
        "vertica": {
            "options": [],
            "before" : [],
            "args": "-h {host} -p {port} -U \"{username}\" -w \"{password}\" -d \"{database}\"",
            "queries": {
                "desc" : {
                    "query": "select '|' || table_schema || '.' || table_name || '|' as tblname from v_catalog.tables where is_system_table = false",
                    "options": ["--tuples-only", "--no-vsqlrc"]
                },
                "columns": {
                    "query": "select '|' || table_name || '.' || column_name || '|' as tblname from v_catalog.columns where is_system_table = false order by table_name, ordinal_position",
                    "options": ["--tuples-only", "--no-vsqlrc"]
                },
                "desc table": {
                    "query": "\\d %s",
                    "options": []
                },
                "show records": {
                    "query": "select * from {0} limit {1}",
                    "options": []
                },
                "explain plan": {
                    "query": "explain {0};",
                    "options": []
                }
            }
        },
        "sqsh": {
            "options": [],
            "before": ["\\set semicolon_cmd=\"\\go -mpretty -l\""],
            "args": "-S {host}:{port} -U\"{username}\" -P\"{password}\" -D{database}",
            "queries": {
                "desc": {
                    "query": "select concat(table_schema, '.', table_name) from information_schema.tables order by table_name;",
                    "options": [],
                    "before" :["\\set semicolon_cmd=\"\\go -mpretty -l -h -f\""]
                },
                "columns": {
                    "query": "select concat(table_name, '.', column_name) from information_schema.columns order by table_name, ordinal_position;",
                    "options": [],
                    "before" :["\\set semicolon_cmd=\"\\go -mpretty -l -h -f\""]
                },
                "desc table": {
                    "query": "exec sp_columns \"%s\";",
                    "options": [],
                    "before": ["\\set semicolon_cmd=\"\\go -mpretty -l -h -f\""]
                },
                "show records": {
                    "query": "select top {1} * from \"{0}\";",
                    "options": [],
                    "before": ["\\set semicolon_cmd=\"\\go -mpretty -l -h -f\""]
                }
            }
        },
        "sqlite": {
            "options": ["-column", "-header"],
            "before": [],
            "args": "\"{database}\"",
            "queries": {
                "desc" : {
                    "query": ".headers off\nSELECT '|' || name || '|' FROM sqlite_master WHERE type='table';",
                    "options": ["-noheader"]
                },
                "desc table": {
                    "query": ".schema \"%s\"",
                    "options": ["-column", "-header"]
                },
                "show records": {
                    "query": "select * from \"{0}\" limit {1};",
                    "options": ["-column", "-header"]
                },
                "explain plan": {
                    "query": "EXPLAIN QUERY PLAN {0};",
                    "options": ["-column", "-header"]
                }
            }
        },
        "firebird": {
            "options": [],
            "before": [],
            "args": "-u \"{username}\" -p \"{password}\" \"{host}/{port}:{database}\"",
            "queries": {
                "desc" : {
                    "query": "select '|' || rdb$relation_name || '|' from rdb$relations where rdb$view_blr is null and (rdb$system_flag is null or rdb$system_flag = 0);",
                    "options": []
                },
                "desc table": {
                    "query": "show table \"%s\";",
                    "options": []
                },
                "show records": {
                    "query": "select first 100 * from \"%s\";",
                    "options": []
                }
            }
        }
    }
}