# Using Visual Studio Code for Writing SQL Queries in Ignition

**URL:** <https://forum.inductiveautomation.com/t/using-visual-studio-code-for-writing-sql-queries-in-ignition/100473>\
**Category:** Ignition\
**Tags:** python, database, ignition81, scripting\
**Created:** [January 6, 2025, 11:15am UTC](https://forum.inductiveautomation.com/t/using-visual-studio-code-for-writing-sql-queries-in-ignition/100473 "2025-01-06T11:15:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gaurav.Shitole](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/gaurav.shitole/32/72050_2.png) [@Gaurav.Shitole](https://forum.inductiveautomation.com/u/Gaurav.Shitole)\
**Post date:** [January 6, 2025, 11:15am UTC](https://forum.inductiveautomation.com/t/using-visual-studio-code-for-writing-sql-queries-in-ignition/100473/1 "2025-01-06T11:15:27Z")

</div>

Hello everyone,

I wanted to know if anyone is using Visual Studio Code to write SQL queries for Ignition projects. Specifically, I am looking for a way to:

1. Write SQL queries directly in Visual Studio Code.
2. Automatically create a named query within the Ignition project upon saving.
3. Easily modify existing named queries through the same setup.

I tried adding the Ignition project folder as a workspace in Visual Studio Code, but I encountered an issue when attempting to save the query file. It gives me an error saying **"Insufficient Permission, retry as Administrator."**

Has anyone else tried this workflow? If so, how did you overcome this issue? Any tips or tools you recommend for better integration between Visual Studio Code and Ignition for handling named queries?  
I would also like to use the same approach for python scripts later.

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [January 6, 2025, 4:07pm UTC](https://forum.inductiveautomation.com/t/using-visual-studio-code-for-writing-sql-queries-in-ignition/100473/2 "2025-01-06T16:07:41Z")

</div>

I don't think this is an idea worth pursuing. Ignition's named queries have their own parameter syntax which is unlikely to work in Visual Studio. In addition,

> [@Running sql script from Ignition](https://forum.inductiveautomation.com/t/running-sql-script-from-ignition/78478/2):
>
> JDBC doesn't officially support SQL scripts. Just statements. Some JDBC drivers implement some SQL scripting syntax, but you are kind of on your own. If you really need to run a script in your DB, use a stored procedure. An SP can be called with a single statement.

Your best bet would be to develop your SQL in whatever environment you want and then paste it into Ignition's Named Query editor, fix the parameters and test it there.

Regarding your error message, the user that VSC is running under doesn't appear to have rights to the Ignition folder. That's a Windows permissions issue.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [January 6, 2025, 4:21pm UTC](https://forum.inductiveautomation.com/t/using-visual-studio-code-for-writing-sql-queries-in-ignition/100473/3 "2025-01-06T16:21:10Z")

</div>

@kgamble's [Flint extension](https://marketplace.visualstudio.com/items?itemName=Keith-gamble.ignition-flint) supports easier editing for project library scripts and Perspective scripts. You could probably ask him/file a PR against the repo adding support for editing named queries in their modern saved representation, since it's just a .sql file and some metadata in the `resource.json`.