{"id":43621,"library":"picos-mod-mysql","title":"picos-mod-mysql","description":"A MySQL database module for the picos framework, version 0.5.4. This package provides MySQL connectivity and query capabilities specifically designed for picos applications. It is maintained as part of the picos ecosystem and released on an as-needed basis. Key differentiators include tight integration with picos' architecture and simplified configuration.","status":"active","version":"0.5.4","language":"javascript","source_language":"en","source_url":null,"tags":["javascript","picos","mysql","module"],"install":[{"cmd":"npm install picos-mod-mysql","lang":"bash","label":"npm"},{"cmd":"yarn add picos-mod-mysql","lang":"bash","label":"yarn"},{"cmd":"pnpm add picos-mod-mysql","lang":"bash","label":"pnpm"}],"dependencies":[],"imports":[{"note":"Package uses ESM by default; use import rather than require.","wrong":"const mysql = require('picos-mod-mysql')","symbol":"default","correct":"import mysql from 'picos-mod-mysql'"},{"note":"If using named export, ensure correct syntax.","wrong":"import mysql from 'picos-mod-mysql'","symbol":"mysql","correct":"import { mysql } from 'picos-mod-mysql'"},{"note":"Class export is named, not default.","wrong":"import PicosMySQL from 'picos-mod-mysql'","symbol":"PicosMySQL","correct":"import { PicosMySQL } from 'picos-mod-mysql'"}],"quickstart":{"code":"import mysql from 'picos-mod-mysql';\n\nconst connection = mysql.createConnection({\n  host: process.env.MYSQL_HOST ?? 'localhost',\n  user: process.env.MYSQL_USER ?? 'root',\n  password: process.env.MYSQL_PASSWORD ?? '',\n  database: process.env.MYSQL_DATABASE ?? 'test'\n});\n\nconnection.query('SELECT 1 + 1 AS solution', (error, results) => {\n  if (error) throw error;\n  console.log('Result:', results[0].solution);\n});\n\nconnection.end();","lang":"typescript","description":"Creates a MySQL connection, runs a simple query, and logs the result."},"warnings":[{"fix":"Set MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE environment variables before running.","message":"The package may require a running MySQL server and appropriate credentials. Ensure environment variables are set or provide default values.","severity":"gotcha","affected_versions":">=0.0.0"}],"env_vars":null,"search_vec":"'0.5.4':14 'applic':27 'architectur':52 'as-need':41 'basi':44 'capabl':22 'configur':55 'connect':19 'databas':7 'design':24 'differenti':46 'ecosystem':36 'framework':12 'includ':47 'integr':49 'javascript':56 'key':45 'maintain':30 'mod':3 'modul':8,59 'mysql':4,6,18,58 'need':43 'packag':16 'part':32 'pico':2,11,26,35,51,57 'picos-mod-mysql':1 'provid':17 'queri':21 'releas':38 'simplifi':54 'specif':23 'tight':48 'version':13","created_at":"2026-06-05T17:00:40.708549+00:00","updated_at":"2026-06-05T17:00:40.708549+00:00","problems":[{"fix":"Run `npm install picos-mod-mysql` and use `import mysql from 'picos-mod-mysql'`.","cause":"Forgetting to import or install the package.","error":"Error: Cannot find module 'mysql'"},{"fix":"Use `import mysql from 'picos-mod-mysql'` instead of named import.","cause":"Incorrect import style (e.g., using named import when default is needed).","error":"TypeError: mysql.createConnection is not a function"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":null,"github":null,"docs":null,"changelog":null,"pypi":null,"npm":"picos-mod-mysql","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}