MariaDB Parser

Overview

MariaDB Parser validates MariaDB SQL syntax using node-sql-parser WITHOUT requiring a real MariaDB database.

Specifications

Property	Value
Language ID	mariadb-parser
Base OS	Alpine Linux 3.20
Runtime	Node.js 22
Parser	node-sql-parser
Rootfs Size	500 MB
Memory	256 MB
File Extension	.sql
Execution Time	~2.8s

Infrastructure

Step 1: Create Docker Directory

Create working directory for MariaDB parser

mkdir -p /tmp/docker/mariadb-parser
cd /tmp/docker/mariadb-parser

Step 2: Create mariadb-run.js Script

Create Node.js parser wrapper script

cat > mariadb-run.js << 'EOF'
#!/usr/bin/env node
const fs = require('fs');
const { Parser } = require('node-sql-parser');

const parser = new Parser();
const DATABASE = 'MariaDB';

function main() {
    const args = process.argv.slice(2);
    if (args.length === 0) {
        console.error('Usage: mariadb-run.js <file.sql>');
        process.exit(1);
    }

    const sqlFile = args[0];
    let sql;
    try {
        sql = fs.readFileSync(sqlFile, 'utf8').trim();
    } catch (err) {
        console.error(`Error reading file: ${err.message}`);
        process.exit(1);
    }

    if (!sql) {
        console.error('Error: Empty SQL file');
        process.exit(1);
    }

    try {
        const ast = parser.astify(sql, { database: DATABASE });
        const formatted = parser.sqlify(ast, { database: DATABASE });

        console.log('=== SQL Validation Result ===');
        console.log('Status: VALID');
        console.log('Database: MariaDB');
        console.log('');
        console.log('=== Formatted SQL ===');
        console.log(formatted);
        console.log('');

        if (Array.isArray(ast)) {
            console.log(`=== Statement Summary ===`);
            console.log(`Total statements: ${ast.length}`);
            ast.forEach((stmt, i) => {
                console.log(`  ${i + 1}. ${stmt.type || 'unknown'}`);
            });
        } else {
            console.log('=== Statement Summary ===');
            console.log(`Statement type: ${ast.type || 'unknown'}`);
        }
        process.exit(0);
    } catch (err) {
        console.log('=== SQL Validation Result ===');
        console.log('Status: INVALID');
        console.log('Database: MariaDB');
        console.log('');
        console.log('=== Error Details ===');
        console.error(`Syntax Error: ${err.message}`);
        if (err.location) {
            console.error(`Location: Line ${err.location.start.line}, Column ${err.location.start.column}`);
        }
        process.exit(1);
    }
}

main();
EOF

Step 3: Create Dockerfile

Create Dockerfile with Node.js and parser dependencies

cat > Dockerfile << 'EOF'
FROM node:22-alpine3.20

WORKDIR /opt/sql-parser
RUN npm init -y && npm install node-sql-parser --save

COPY mariadb-run.js /usr/local/bin/mariadb-run
RUN chmod +x /usr/local/bin/mariadb-run

ENV NODE_PATH=/opt/sql-parser/node_modules

CMD ["node", "--version"]
EOF

Step 4: Build and Push Docker Image

Build and push Docker image to ttl.sh registry

docker build -t ttl.sh/llm-fc-mariadb-parser:24h .
docker push ttl.sh/llm-fc-mariadb-parser:24h

Step 5: Create Rootfs

Create rootfs from Docker image

sudo infra.operator rootfs from-docker \
    --name mariadb-parser \
    --image ttl.sh/llm-fc-mariadb-parser:24h \
    --size 500

Step 6: Create Snapshot

Create VM snapshot for fast boot

sudo infra.operator snapshot create \
    --lang mariadb-parser \
    --mem 256 \
    --vcpus 1

Step 7: Upload to S3

Upload rootfs and snapshot to S3 bucket

export AWS_ACCESS_KEY_ID="your-key"
export AWS_SECRET_ACCESS_KEY="your-secret"
export AWS_DEFAULT_REGION="us-east-1"

sudo -E infra.operator rootfs upload --lang mariadb-parser --bucket runner-codes
sudo -E infra.operator snapshot upload --lang mariadb-parser --bucket runner-codes

Step 8: Test Execution

Test parser with sample SQL

sudo infra.operator host \
    --lang mariadb-parser \
    --snapshot \
    --mem 256 \
    --vcpus 1 \
    --code "SELECT * FROM users WHERE status = 'active';"

Examples

Hello World

Request

{
  "trace_id": "mariadb-hello-001",
  "lang": "mariadb-parser",
  "code": "SELECT 'Hello from MariaDB Parser!' AS message;",
  "timeout": 30
}

Response

{
  "trace_id": "mariadb-hello-001",
  "stdout": "=== SQL Validation Result ===\nStatus: VALID\nDatabase: MariaDB\n\n=== Formatted SQL ===\nSELECT 'Hello from MariaDB Parser!' AS `message`\n\n=== Statement Summary ===\nTotal statements: 1\n  1. select\n",
  "stderr": "",
  "exit_code": 0
}

INSERT with ON DUPLICATE KEY UPDATE

Request

{
  "trace_id": "mariadb-upsert-001",
  "lang": "mariadb-parser",
  "code": "INSERT INTO users (id, name, email) VALUES (1, 'John', '[email protected]')\nON DUPLICATE KEY UPDATE name = VALUES(name), email = VALUES(email);",
  "timeout": 30
}

Response

{
  "trace_id": "mariadb-upsert-001",
  "stdout": "=== SQL Validation Result ===\nStatus: VALID\nDatabase: MariaDB\n\n=== Formatted SQL ===\nINSERT INTO `users` (`id`, `name`, `email`) VALUES (1, 'John', '[email protected]') ON DUPLICATE KEY UPDATE `name` = VALUES(`name`), `email` = VALUES(`email`)\n\n=== Statement Summary ===\nTotal statements: 1\n  1. insert\n",
  "stderr": "",
  "exit_code": 0
}

Executor Configuration

Go code

// pkg/guest/executor.go
"mariadb-parser": {
    Name:      "mariadb-parser",
    Extension: ".sql",
    Command:   "/usr/local/bin/node",
    Args:      []string{"/usr/local/bin/mariadb-run"},
    Env:       []string{"NODE_PATH=/opt/sql-parser/node_modules"},
},