@robinpath/mysql

MySQL/MariaDB client with connection pooling, parameterized queries, transactions, and CRUD operations

Why use this module?

The mysql module lets you:

• Execute SQL query
• Insert a row
• Insert multiple rows
• Update rows
• Delete rows

All functions are callable directly from RobinPath scripts with a simple, consistent API.

Installation

npm install @robinpath/mysql

Quick Start

1. Set up credentials

mysql.connect {"host": "localhost", "user": "root", "database": "mydb"}

2. Execute SQL query

mysql.query "SELECT * FROM users WHERE id = ?" [1]

Available Functions

Function	Description
mysql.connect	Connect to MySQL database
mysql.query	Execute SQL query
mysql.insert	Insert a row
mysql.insertMany	Insert multiple rows
mysql.update	Update rows
mysql.remove	Delete rows
mysql.transaction	Execute queries in transaction
mysql.tables	List all tables
mysql.describe	Describe table structure
mysql.count	Count rows
mysql.close	Close connection pool
mysql.closeAll	Close all connection pools

Examples

Execute SQL query

mysql.query "SELECT * FROM users WHERE id = ?" [1]

Insert a row

mysql.insert "users" {"name": "Alice", "email": "alice@example.com"}

Insert multiple rows

mysql.insertMany "users" [{"name": "Alice"}, {"name": "Bob"}]

Integration with RobinPath

import { RobinPath } from "@wiredwp/robinpath";
import Module from "@robinpath/mysql";

const rp = new RobinPath();
rp.registerModule(Module.name, Module.functions);
rp.registerModuleMeta(Module.name, Module.functionMetadata);

const result = await rp.executeScript(`
  mysql.connect {"host": "localhost", "user": "root", "database": "mydb"}
  mysql.query "SELECT * FROM users WHERE id = ?" [1]
`);

Full API Reference

See MODULE.md for complete documentation including all parameters, return types, error handling, and advanced examples.

Related Modules

• @robinpath/postgres — PostgreSQL module for complementary functionality
• @robinpath/mongo — Mongo module for complementary functionality
• @robinpath/redis — Redis module for complementary functionality
• @robinpath/supabase — Supabase module for complementary functionality
• @robinpath/firebase — Firebase module for complementary functionality

License

MIT