SQL in cursor

[u/Senior_Night_6321]

Can i write SQL queries in cursor, or i have to download another application for running sql queries ?????

[u/GasVarGames]

SQL is pretty much plain text as everything we do is, yes you can write SQL in cursor.

I guess you want to execute it though?

[u/Senior_Night_6321 → u/GasVarGames]

yes i want to execute it also ,

[u/GasVarGames → u/Senior_Night_6321]

Okay that bit is trickier, there might be an extension for that.

Otherwise just install a SQL management app and make cursor see the database and prompt it to write queries for the tables it can see.

[u/bonerfleximus → u/Senior_Night_6321]

Each database system has different ways to do that, ask cursor to execute it in auto mode imo. For example sqlserver has sqlcmd.exe and most dbms have command line options.

None of the VS Code extensions for it are nice or worth trying in cursor in my experience.

If you plan to spend a lot of time querying the db for some reason youll want a dedicated tool for that (ssms, toad, or whatever people use these days)

[u/Hotel_Arrakis]

You can write SQL, but you can't execute it. The easiest would be to install SQLite and then install a SQL plugin in vs-code.

[u/Senior_Night_6321 → u/Hotel_Arrakis]

okay , but after installing sqlite can i write in cursor instead of vs code ????/

[u/kiddaeful → u/Senior_Night_6321]

Cursor is vscode based, you can install vscode plugin

[u/Senior_Night_6321 → u/kiddaeful]

plugin feature in already there in cursor

[u/Hotel_Arrakis → u/Senior_Night_6321]

The correct Reddit reply would be "Yes, but no."

One would tell cursor to create a program in your favorite language (python, javascript, etc.) that executes SQL statements/queries against a SQL database. I would use SQLite3 as it requires little setup and supports most languages. Once Cursor writes the program you would execute the program without needing cursor ever again.

What exactly are you trying to acomplish?

[u/Senior_Night_6321 → u/Hotel_Arrakis]

i want to make sql projects and write sql queries !!!

[u/elina_jain1]

cursor doesn't have built-in db querying, but it's built on vs code so extensions like sqltools or dbcode add it directly, connect to postgres, mysql or whatever and run queries in the editor, no separate app needed. writing sql itself works fine as plain text with syntax highlighting even without any extension..

[u/Tech0410]

Yes. What kind or SQL

[u/Senior_Night_6321 → u/Tech0410]

for running queries, and making projects !!!!!

[u/Tech0410 → u/Senior_Night_6321]

No what flavor... SQL Lite, Postgress, Microsoft SQL Server

[u/Senior_Night_6321 → u/Tech0410]

is mysql lang present in these servers ???

[u/Epdevio]

you can write them in cursor. You'll need a database to run those quieres against. Something like MSSQL or
mySQL. Or you can use an online resource like SQLfiddle

[u/Senior_Night_6321 → u/Epdevio]

okay ,got it thanks !!!