Sublime Forum

Problem getting SQL tools to work

#1

I set up this connection in “Preferences -> Package Settings -> SQLTools -> Connections” like this:

    "connections": {
        "MyMariaDB": {
              "type": "mariadb",
              "host": "localhost",
              "port": 3306,

Then to run a sql file I opened one and hit CTRL-E twice and nothing happened.
Then I tried CTRL-SHFT-P and entered ST: Execute and nothing happened.

ST: About said I was using SQLTools V.0.9.12

The thing that is missing is how to point a SQL file to my connection. There is only one but…

0 Likes

#2

Have you defined the cli command?

What’s in your “Preferences -> Package Settings -> SQLTools -> Settings”?

0 Likes

#3

I don’t know anything about the cli command, and my settings is empty.

0 Likes

#4

It has been a loooooooooong time since I used SQL tools, but you need to configure Settings and Connections:
image

Under settings, you need to set the cli path to whatever SQL you are using, so that it can execute the request:

Then under Connections, the credentials for each DB

8 years ago (wow!) I recorded this screen video, that might help:
SQLTools and Sublime Text - Executing SQL, directly in your editor - YouTube

0 Likes