CRUD Lambda RDS Template

index.js

'use strict';

var mysql = require('mysql');

exports.handler = (event, context, callback) => {

    var connection = mysql.createConnection({
        host     : 'rds.amazonaws.com',
        database : 'database',
        user     : 'user',
        password : 'password',
        port     : '3306'
    });

    connection.connect(function(err) {
      if (err) {
        console.error('error connecting: ' + err.stack);
        return;
      }
     
      console.log('connected as id ' + connection.threadId);
    });

    switch (event.method) {
        case 'DELETE':

            callback(null, {
                statusCode: '400',
                body: "No Delete method",
                headers: {
                    'Content-Type': 'application/json',
                },
            });

            break;
        case 'GET':

            callback(null, {
                statusCode: '400',
                body: "No GET method",
                headers: {
                    'Content-Type': 'application/json',
                },
            });

            break;
        case 'POST':

            var Id = event.query.code;
            connection.query('SELECT * FROM table WHERE code = "' + Id + '"', function(err, rows, fields) {

                callback(null, {
                    event: event,
                    statusCode: err ? '400' : '200',
                    body: err ? err.message : rows,
                    headers: {
                        'Content-Type': 'application/json',
                    },
                });

            });

            break;
        case 'PUT':

            callback(null, {
                statusCode: '400',
                body: "No PUT method",
                headers: {
                    'Content-Type': 'application/json',
                },
            });

            break;
        default:

            callback(null, {
                event: event,
                statusCode: '400',
                body: "No PUT method",
                headers: {
                    'Content-Type': 'application/json',
                },
            });

    }

    connection.end();

};

Use this if you love SQL injection