Express Full-Stack Snippets

The ultimate VS Code companion for building Express + SQLite full-stack applications.
Includes 45+ schema-aware snippets and inline code generation.

Features

45+ Production Snippets — Express server setup, CRUD routes, JWT auth, bcrypt, CORS, file uploads, pagination, and more.
Schema-Aware Dynamic Generation — Register your database tables and instantly generate CRUD routes, HTML lists, forms, and full-page UIs tailored to your schema.
SQL Query Builder — Interactive visual query builder with JOIN, GROUP BY, HAVING, aggregates, and SQL preview.
Schema Visualizer — Visualize your registered tables, columns, and foreign key relationships.
Multi-Language Support — Works in JavaScript, TypeScript, JSX/TSX, JSON, and HTML files.

Installation

From VSIX (Recommended)

Open VS Code -> Extensions sidebar (Ctrl+Shift+X)
Click ... (More Actions) -> Install from VSIX...
Select node-sqlite-snippets-3.2.2.vsix
Reload VS Code if prompted

From VS Code Marketplace

Search for "Express Full-Stack Snippets" in the Extensions panel and click Install.

Quick Start

# 1. Create your server file
#    Type 'njs-server' in server.js -> press Tab
#
# 2. Add package.json
#    Type 'njs-pkg' in package.json -> press Tab -> npm install
#
# 3. Start your server
node server.js
#    Your REST API is live at http://localhost:3000

Snippets Reference

Setup & Server

Prefix	Description
`njs-server` `njs-sv`	Full Express + Better-SQLite3 server with DB, CRUD, graceful shutdown
`njs-express` `njs-ex`	Minimal Express server skeleton
`njs-db` `njs-dbc`	SQLite connection boilerplate
`njs-setup` `njs-st`	Express + static files + DB setup
`njs-pkg` `njs-pk`	package.json with all deps (express, better-sqlite3, cors, bcrypt, jwt, dotenv, nodemailer)

CRUD Routes

Prefix	Description
`njs-get` `njs-g`	GET route with SELECT query
`njs-post` `njs-p`	POST route with INSERT
`njs-put` `njs-u`	PUT route with UPDATE
`njs-del` `njs-d`	DELETE route (or deactivate pattern)
`njs-router` `njs-rt`	Express Router with all CRUD boilerplate

Authentication

Prefix	Description
`njs-users-table` `njs-ut`	Users table schema (email, password_hash, role, reset token)
`njs-jwt` `njs-jt`	JWT sign + verify helpers
`njs-auth` `njs-aw`	JWT verify middleware with optional role check
`njs-reg` `njs-rg`	Register route with bcrypt hashing
`njs-log` `njs-lg`	Login route (verify credentials + return JWT)
`njs-forgot` `njs-fp`	Forgot password route with email reset
`njs-hash` `njs-hs`	bcrypt hash + compare utility functions

Security

Prefix	Description
`njs-cors` `njs-cor`	CORS configuration
`njs-helmet` `njs-hm`	Helmet security headers
`njs-rate` `njs-rl`	Rate limiter with express-rate-limit
`njs-err` `njs-er`	Centralized error handler middleware

Utilities

Prefix	Description
`njs-mw`	Custom middleware template
`njs-async` `njs-as`	Async error wrapper for Express routes
`njs-env` `njs-envcfg`	dotenv configuration
`njs-val` `njs-vl`	express-validator input validation
`njs-read` `njs-rd`	fs.readFile helper
`njs-write` `njs-wr`	fs.writeFile helper
`njs-path` `njs-ph`	path.join utility
`njs-page` `njs-pg`	SQL pagination (LIMIT/OFFSET)
`njs-res` `njs-rsp`	Standardized response wrapper
`njs-tx` `njs-trn`	SQLite transaction wrapper

Frontend / Client

Prefix	Description
`njs-fetch` `njs-fc`	Fetch API wrapper with error handling
`njs-api` `njs-apc`	API Client class with CRUD methods
`njs-list-js` `njs-ls`	Fetch + render dynamic HTML list
`njs-form-js` `njs-fj`	Form submission handler
`njs-page-js` `njs-pj`	Full page JS (load, add, update, delete)
`njs-add-js` `njs-aj`	Standalone add function
`njs-update-js` `njs-uj`	Standalone update function
`njs-delete-js` `njs-dj`	Standalone delete function

Other

Prefix	Description
`njs-socket` `njs-sk`	Socket.io server setup
`njs-upload` `njs-up`	Multer file upload configuration
`njs-mail` `njs-em`	Nodemailer email sender
`njs-logger` `njs-lg`	Morgan HTTP request logger
`njs-cookie` `njs-ck`	Cookie-parser middleware

Schema Registry & Dynamic Generation

Command	Description
`njs: Register Table`	Register a table schema for code generation
`njs: Remove Table`	Remove a registered table
`njs: Modify Table Fields`	Update fields of a registered table
`njs: Register this table`	Register from a CREATE TABLE SQL statement
`njs: Schema Status`	View all registered schemas
`njs: Add Foreign Key`	Define foreign key relationships
`njs: Remove Foreign Key`	Remove foreign key relationships
`njs: Schema Visualizer`	Open visual schema diagram
`njs: Generate All Tables`	Generate all registered tables at once

Requirements

VS Code 1.74.0 or higher
Node.js 14.x or higher

License

This project is licensed under the MIT License.

Made with love by weonlyliveonce

NODEJS EXPRESS WORKBENCH

weonlyliveonce