SeeQL is an extension meant to help users when it comes to working with SQL on Visual Studio Code. Overall, it’s meant to help users' overall quality of life when it comes to working with it. Through visualization, helping build SQL queries, and simplifying issues that come with working with SQL. Issues like making up your own SQL statements, knowing if you have the expected output, and visualizing in general. SQL, at times, feels very difficult to work with. We want our extension to make it feel as simple as possible for the user.
Features
OpenDB:
Opens a .db file to run querries
On success, prompts button left with open DB
RunQuery:
Requires a DB to be opened by OpenDB command
Requires user to write a sql statment inside sql file
On click run querry, table appear with stats
CreateERDiagram
Creates a E/R diagram given a sql file with valid query
Before running command, have valid folder open in vscode file explorer holding related SQL Create Tables
DISCLAIMER: DO NOT PUT INLINE COMMENTS IN SQL STATEMENTS. Due to custom SQL parser for this, we cannot have inline comments for this or any sort of comments. Keep it as barebones as possible.
CreateRelationalAlgebra
Creates a relatioal algerbra diagram given a sql file with valid query
Before running command, have valid folder open in vscode file explorer holding related SQL Queries
Connect to CloudBase
Connect to Azure
Enter your Azure SQL Server
Enter Azure SQL Username
Enter password
Enter Azure SQL Database Name
Create Database from CSV/SQL File
Select a CSV File
Then rename the db file and that's it
GenerateSQLQuery (WIP + Dev excluseive for time being)
