{"id":46473,"library":"sqlite-plugin-red","title":"SQLite Tab RED","description":"A Node-RED sidebar plugin for visualizing and editing SQLite database structures. Current version 0.0.3, alpha stage with infrequent releases. Provides a UI within Node-RED to create, rename, delete tables and columns. Requires node-red-node-sqlite as a peer dependency. No input sanitization yet; relies on SQLite error feedback. Targeted at Node-RED developers needing a graphical SQLite schema editor.","status":"active","version":"0.0.3","language":"javascript","source_language":"en","source_url":null,"tags":["javascript","node-red","sqlite","database","db","sql"],"install":[{"cmd":"npm install sqlite-plugin-red","lang":"bash","label":"npm"},{"cmd":"yarn add sqlite-plugin-red","lang":"bash","label":"yarn"},{"cmd":"pnpm add sqlite-plugin-red","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Peer dependency required for SQLite operations","package":"node-red-node-sqlite","optional":false}],"imports":[{"note":"Install as Node-RED plugin; no direct module import.","wrong":"require('sqlite-plugin-red') (cannot be required as a standalone module)","symbol":"sqlite-plugin-red","correct":"plugins: [require('sqlite-plugin-red')]"}],"quickstart":{"code":"cd ~/.node-red\nnpm install node-red-node-sqlite sqlite-plugin-red\n# Restart Node-RED; side tab will appear.\n# Create or open a SQLite file via the tab interface.","lang":"javascript","description":"Installs the plugin and its dependency, then shows how to access the sidebar tab in Node-RED."},"warnings":[{"fix":"Manually verify SQL constraints before confirming changes.","message":"No input validation: invalid SQL types or missing INTEGER for autoincrement will fail silently.","severity":"gotcha","affected_versions":">=0.0.0"},{"fix":"Pin to specific version and test upgrades thoroughly.","message":"Version 0.0.3 is alpha; API may change without notice.","severity":"deprecated","affected_versions":">=0.0.0"}],"env_vars":null,"search_vec":"'0.0.3':19 'alpha':20 'column':38 'creat':33 'current':17 'databas':15,75 'db':76 'delet':35 'depend':48 'develop':63 'edit':13 'editor':69 'error':56 'feedback':57 'graphic':66 'infrequ':23 'input':50 'javascript':70 'need':64 'node':6,30,41,43,61,72 'node-r':5,29,60,71 'node-red-node-sqlit':40 'peer':47 'plugin':9 'provid':25 'red':3,7,31,42,62,73 'releas':24 'reli':53 'renam':34 'requir':39 'sanit':51 'schema':68 'sidebar':8 'sql':77 'sqlite':1,14,44,55,67,74 'stage':21 'structur':16 'tab':2 'tabl':36 'target':58 'ui':27 'version':18 'visual':11 'within':28 'yet':52","created_at":"2026-06-07T13:00:05.806095+00:00","updated_at":"2026-06-07T13:00:05.806095+00:00","problems":[{"fix":"npm install node-red-node-sqlite","cause":"Missing peer dependency","error":"sqlite-plugin-red: Cannot find module 'node-red-node-sqlite'"},{"fix":"Ensure node-red-node-sqlite is installed and Node-RED restarted.","cause":"node-red-node-sqlite not installed or not loaded","error":"Cannot read properties of undefined (reading 'sqlite')"}],"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":"sqlite-plugin-red","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-07","next_check":"2026-09-05","install_tag":null}}