🗄️ SQL Helper

SQL Helper is an advanced Visual Studio Code extension that accelerates database development by providing:

70+ professional snippets for SQL, Java JDBC, Python, and JavaScript/TypeScript
Smart SQL Analyzer that detects errors in any language
SQL Formatter for automatic readability improvement

Generate production-ready code in seconds — from complex SQL queries to full CRUD methods with transactions and error handling.

🎯 Main features

📊 Snippets SQL (40+ templates)

Selection: Basic SELECT, WHERE, LIMIT, OFFSET, ORDER BY, GROUP BY, DISTINCT, JOINs
Manipulation: INSERT (single & multiple), UPDATE, DELETE
Structure: CREATE TABLE (con tipos de datos avanzados), IF NOT EXISTS, Foreign Keys
DDL: ALTER TABLE (ADD/DROP/MODIFY columns), CREATE INDEX, DROP TABLE
Advanced Queries: JOINs (LEFT, RIGHT, INNER), UNION, CASE WHEN, Subqueries
Functions: String (CONCAT, SUBSTRING, UPPER/LOWER, REPLACE), Dates (NOW, DATE_ADD, DATEDIFF)
BD: Views, Triggers, Stored Procedures
Utility: file generator, backup/restore

☕ Java JDBC (9+ methods)

JDBC connection with connection pool
SELECT with List, SELECT by ID, SELECT with conditions
INSERT, UPDATE, DELETE using PreparedStatement
COUNT, full transactions
Exception handling and try-with-resources

🐍 Python (15+ snippets)

SQLite, MySQL (mysql-connector), PostgreSQL connections
SELECT (fetchall, fetchone), INSERT (single & multiple)
UPDATE, DELETE with affected rows
Transactions with commit/rollback
Context managers, SQLAlchemy ORM

📜 JavaScript/TypeScript (15+ snippets)

MySQL (mysql2/promise), PostgreSQL (pg) connections
SELECT, INSERT, UPDATE, DELETE with async/await
Reusable methods, COUNT
Runtime CREATE TABLE
Transactions with rollback
ORM integration (Sequelize)

🔍 SQL Analyzer (NEW) — Automatically detects errors

Detects 8+ error types:

Missing semicolon (;)
Unbalanced quotes (', ")
Unbalanced parentheses
SELECT without FROM
INSERT without VALUES
UPDATE/DELETE WITHOUT WHERE (dangerous) ⚠️
Reserved keywords used as identifiers

Supports multiple languages:

.sql — Raw SQL
.java — Strings: "SELECT * FROM..."
.js/.ts — Template literals: const sql = SELECT...
.py — Strings: sql = "SELECT..."

Displays errors in:

Problems Panel (native VS Code integration)
Interactive QuickPick (select for details)
Output Channel (detailed logs)

🎨 SQL Formatter (NEW) — Beautify queries

Automatically reformats SQL
Adds line breaks to keywords (SELECT, FROM, WHERE, JOIN...)
Cleans excessive whitespace
Works in all supported languages

✨ Additional Features

Automatic language detection
Smart search with descriptions
Emoji-based categorization (📖 SELECT, ✏️ CRUD, 🏗️ DDL…)
Full logging with timestamps
Robust error reporting
Customizable keybindings (Ctrl+Alt+S/A/F/J)

⚡ Installation

From the Marketplace

Open VS Code
Go to Extensions (Ctrl+Shift+X)
Search for SQL Helper
Click Install or visit:

👉 SQL Helper on Visual Studio Marketplace
Install SQL Helper

From VSIX (development)

npm install
npm run compile
vsce package
code --install-extension sql-helper-*.vsix

⌨️ Quick Keybindings

Command	Shortcut	Description
Insert Snippet	`Ctrl+Alt+S`	Opens snippet menu
Analyze SQL	`Ctrl+Alt+A`	Detects SQL issues
Format SQL	`Ctrl+Alt+F`	Reformats query
Generate Python Project	`Ctrl+Alt+P`	Create Flask/FastAPI project
Generate JavaScript/TypeScript Project	`Ctrl+Alt+J`	Create Express/Nest/Next project

macOS: Replace Ctrl with Cmd

💡 Quick Usage

1️⃣ Insert Snippet (`Ctrl+Alt+S`)

1. Open a .sql, .java, .py, .js or .ts file
2. Press Ctrl+Alt+S
3. Type to search (e.g. "SELECT", "INSERT")
4. Press Enter
5. Code is inserted automatically

2️⃣ Analyze SQL (`Ctrl+Alt+A`)

1. Open a file containing SQL
2. Press Ctrl+Alt+A
3. Errors appear in:
   - Problems Panel
   - QuickPick
4. Select an error for details

3️⃣ Format SQL (`Ctrl+Alt+F`)

1. Select SQL query (or whole file)
2. Press Ctrl+Alt+F
3. Query is formatted automatically

4️⃣ Generate Python Project (`Ctrl+Alt+P`)

1. Press Ctrl+Alt+P
2. Choose framework (Flask or FastAPI)
3. Select Python version (3.10, 3.11, 3.12)
4. Choose database (PostgreSQL, MySQL, SQLite)
5. Select folder
6. Project folder with virtualenv, DB module, models, CRUD, and README is generated

5️⃣ Generate JavaScript/TypeScript Project (`Ctrl+Alt+J`)

1. Press Ctrl+Alt+J
2. Choose framework:
   - Express.js: Minimalist Node.js backend
   - NestJS: Full-featured TypeScript backend
   - Next.js: React-based frontend + backend
3. Select project folder
4. Full project scaffolding is generated:
   - Folder structure
   - package.json with dependencies
   - Starter files (index.js, main.ts, app.module.ts, pages/index.js)

🔍 SQL Analyzer Examples

Detect Errors

✏️ File: queries.sql
📝 Content:
    UPDATE users SET name = 'John'
    ❌ Missing WHERE clause

⌨️ Press: Ctrl+Alt+A
🎯 Result:
   ✗ UPDATE/DELETE SIN WHERE
   Detected: "Line 1 - UPDATE without WHERE"
   💡 Suggestion: Add WHERE to avoid updating all records

Detecting in Java

// queries.java
String sql = "INSERT INTO users (name) VALUES ('John')" // ❌ Missing ;

⌨️ Press: Ctrl+Alt+A
🎯 Result:
   ✗ MISSING SEMICOLON
   Detected: "Line 1"
   💡 Suggestion: "Add ; at the end of the SQL statement"

Format Query

✏️ Original content:
SELECT a.id,a.name,b.email FROM users a INNER JOIN profiles b ON a.id=b.user_id WHERE a.status='active' ORDER BY a.created_at DESC LIMIT 10

⌨️ Press: Ctrl+Alt+F
🎯 Result:
SELECT a.id, a.name, b.email
FROM users a
INNER JOIN profiles b ON a.id = b.user_id
WHERE a.status = 'active'
ORDER BY a.created_at DESC
LIMIT 10

💻 Snippet Examples

Python Transaction

def transfer_money(from_id, to_id, amount):
    conn = mysql.connector.connect(**config)
    cursor = conn.cursor()
    
    try:
        cursor.execute("UPDATE accounts SET balance = balance - %s WHERE id = %s", 
                       (amount, from_id))
        cursor.execute("UPDATE accounts SET balance = balance + %s WHERE id = %s", 
                       (amount, to_id))
        conn.commit()
    except Exception as e:
        conn.rollback()
        raise e
    finally:
        cursor.close()
        conn.close()

Java Insert

public static void insertUser(User user) throws SQLException {
    String sql = "INSERT INTO users (name, email) VALUES (?, ?)";

    try (Connection conn = DatabaseConnection.getConnection();
         PreparedStatement ps = conn.prepareStatement(sql)) {

        ps.setString(1, user.getName());
        ps.setString(2, user.getEmail());
        ps.executeUpdate();
    }
}

JavaScript Async/Await

async function getUserById(userId) {
    try {
        const [rows] = await pool.query(
            "SELECT * FROM users WHERE id = ?", 
            [userId]
        );
        return rows[0] || null;
    } catch (error) {
        console.error("Database error:", error);
        throw error;
    }
}

📋 Requirements

VS Code: ^1.106.0
Node.js: 14+ (for development)

📝 Changelog

0.5.0 - 2025-12-09

✅ Added Python project generation (Flask/FastAPI) with DB modules and CRUD
✅ Added JavaScript/TypeScript project generation (Express/Nest/Next.js)
✅ Updated keybindings (Ctrl+Alt+P, Ctrl+Alt+J)
✅ Improved README with usage examples

0.1.0 - 2025-12-08

✅ Refactored code into modular structure
✅ Improved logging via Output Channel
✅ 40+ SQL snippets added
✅ 9+ Java JDBC methods
✅ 15+ Python snippets
✅ 15+ JavaScript/TypeScript snippets
✅ Customizable keybindings (Ctrl+Alt+S/A/F)
✅ Enhanced error handling
✅ SQL Analyzer added
✅ SQL Formatter added

0.0.5 - 2025-11-20

Initial release with basic SQL snippets
Basic keybindings for insert snippet

🤝 Contributing

Fork the repo
Create a branch (git checkout -b feature/AmazingFeature)
Commit your changes
Push the branch
Open a Pull Request

📧 Support

Report bugs or request features here: GitHub Issues

📄 License

MIT — Free for commercial and personal use

SQL Helper

marcosgdz03