procedural-mysql

library0.2.4jsnpmunverified

A CLI tool for writing MySQL functions and procedures on the command line and uploading them to a MySQL server. Version 0.2.4, low release cadence (last update likely older). Differentiates by offering a simple file-based workflow with a JSON config and optional file watching, aimed at developers who prefer editing SQL functions in files rather than via GUI tools. Minimal dependencies, no active development observed.

database

npm install procedural-mysql

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · PROCEDURAL-MYSQL

procedural-mysql

databasejavascriptv0.2.4

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

executable

✓ npx procedural-mysql

✗ npm run procedural-mysql

The package is meant to be installed globally or run via npx. Running via npm run without a local install will fail.

Creates a config file, an SQL function file, and uploads all functions to the MySQL server using the CLI.

echo '{ "directory": "sql", "db": { "user": "root", "host": "localhost", "database": "test", "password": "root", "charset": "utf8" } }' > procedural-mysql.config.json mkdir sql echo 'CREATE FUNCTION test (number int) RETURNS int BEGIN return number; END' > sql/test.sql npx procedural-mysql -c procedural-mysql.config.json -g

Debug

Known issues

deprecatedPackage is no longer maintained; last update was years ago.

fix

Consider alternatives like 'db-migrate' or writing custom scripts with mysql2.

affects: 0.2.4

gotchaThe config file uses a .json extension but is referenced with -c flag; the file name must match exactly.

fix

Ensure the config file is named 'procedural-mysql.config.json' or specify correct path with -c option.

affects: 0.2.4

gotchaThe -g flag uploads all functions in the configured directory, which may overwrite existing functions with the same name.

fix

Backup existing functions before using -g.

affects: 0.2.4

Errors

Common errors & fixes

Command not found: procedural-mysql

Package not installed globally or not in PATH.

fix

Run 'npm install -g procedural-mysql' or use 'npx procedural-mysql'.

ERROR: Config file not found

The -c option points to a non-existent file or the default config file is missing.

fix

Create a config file named 'procedural-mysql.config.json' in the project root or specify correct path with -c.

Upgrade

Version history

0.2.4latest on npm

Audit

Dependencies

No dependency data recorded yet.

Agent activity

9 hits · last 30 days

node

Resources

githubhttps://github.com/kourad/procedural-mysql ↗

packageprocedural-mysql ↗

homepagehttps://github.com/kourad/procedural-mysql#readme ↗