Node SQLite Server Snippets

A VS Code snippet extension that generates ready-to-use boilerplate code for Express + SQLite3 + CORS server development. Stop memorizing boilerplate and start shipping faster.

Installation

Option 1: Install from VSIX (Recommended)

1. Open VS Code.
2. Go to the Extensions sidebar (Ctrl+Shift+X).
3. Click the ... (More Actions) menu at the top right → Install from VSIX...
4. Select node-sqlite-snippets-1.0.0.vsix from this folder.
5. Reload VS Code if prompted.

Option 2: Manual Copy

1. Press Ctrl+Shift+P → type "Open Extensions Folder" and select it.
2. Copy this entire VSCODE-EXT folder into that directory.
3. Reload VS Code (Ctrl+Shift+P → "Developer: Reload Window").

Snippets

All snippets work in JavaScript (.js) files. Type the prefix and press Tab or Enter to expand.

Quick Start

1. Create a new file: server.js
2. Type: njs-server
3. Press Tab
4. Edit the placeholders (database name, table name, columns) by pressing Tab to navigate.
5. Install dependencies:

npm init -y
npm install express sqlite3 cors

6. Run the server:

node server.js

Your fully working REST API with an SQLite database is now running on http://localhost:3000.

Example: njs-server Output

This snippet generates a complete working server including:

• express, sqlite3, and cors imports
• Database connection with error handling
• Auto-created table if it doesn't exist
• Full CRUD endpoints:
  • GET / — health check
  • GET /users — list all users
  • GET /users/:id — get one user
  • POST /users — create user
  • PUT /users/:id — update user
  • DELETE /users/:id — delete user
• Graceful shutdown handling (SIGINT)

Tab Stops (Placeholders)

Snippets use ${1:default} placeholders so you can customize values quickly:

• ${1:data.db} → change database filename
• ${2:users} → change table name
• ${3:name} → change column name

Press Tab to jump to the next placeholder. Press Shift+Tab to go back.

Tech Stack

• Runtime: Node.js
• Framework: Express.js
• Database: SQLite3 (sqlite3 package)
• Middleware: CORS, express.json(), express.urlencoded()

Requirements

• VS Code 1.74.0 or higher
• Node.js installed on your machine

License

MIT — Free for personal and commercial use.

Auth Quick Start

Add authentication to your app with modular building blocks:

1. Create your users table:

   • Type njs-users-table in server.js after your DB setup

2. Add auth middleware:

   • Type njs-auth near the top of server.js
   • Use authMiddleware() to protect routes (any valid token)
   • Use authMiddleware('admin') to require a specific role

3. Add registration and login routes:

   • Type njs-reg for POST /auth/register
   • Type njs-log for POST /auth/login

4. (Optional) Add password reset:

   • Type njs-forgot for POST /auth/forgot-password
   • Use njs-mail to send the reset link via email

5. Install all dependencies:

   • Type njs-pkg in package.json
   • Run npm install

Example protected route:

app.get('/api/profile', authMiddleware(), (req, res) => {
  res.json({ user: req.user });
});

app.get('/api/admin', authMiddleware('admin'), (req, res) => {
  res.json({ message: 'Admin only' });
});