{"id":46450,"library":"sqlite-dashboard","title":"sqlite-dashboard","description":"A web-based SQLite viewer and editor for self-hosting, loosely modeled after the Supabase dashboard. v0.2.1 (current stable) allows pointing at one or more SQLite files to get a browser UI with a table browser, data grid, inline editing, schema viewer, SQL editor, and REST API. Requires Node.js. Ships as plain HTML/CSS/JS with no build step. Supports password protection via environment variable. Alternative to commercial tools like TablePlus or Adminer for SQLite, designed for lightweight self-hosted deployments.","status":"active","version":"0.2.1","language":"javascript","source_language":"en","source_url":"https://github.com/EskelCz/sqlite-dashboard","tags":["javascript","sqlite","dashboard","database","viewer","editor"],"install":[{"cmd":"npm install sqlite-dashboard","lang":"bash","label":"npm"},{"cmd":"yarn add sqlite-dashboard","lang":"bash","label":"yarn"},{"cmd":"pnpm add sqlite-dashboard","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"SQLite database driver for Node.js","package":"better-sqlite3","optional":false},{"reason":"HTTP server framework","package":"express","optional":false}],"imports":[{"note":"Package supports both ESM and CJS. This import starts the server.","wrong":"const createDashboard = require('sqlite-dashboard')","symbol":"createDashboard","correct":"import { createDashboard } from 'sqlite-dashboard'"},{"note":"Returns Express app without starting server, useful for testing.","symbol":"createApp","correct":"import { createApp } from 'sqlite-dashboard'"}],"quickstart":{"code":"const { createDashboard } = require('sqlite-dashboard');\n\ncreateDashboard({\n  directory: './data',\n  port: 3000,\n  host: '127.0.0.1',\n});\nconsole.log('Dashboard running at http://127.0.0.1:3000');","lang":"javascript","description":"Start the dashboard by scanning a directory for SQLite files on port 3000."},"warnings":[{"fix":"When using the CLI, always provide a --name for each .db file to avoid confusion.","message":"The `name` property in database config with `--name` flag is applied to databases; if not specified, the filename (without extension) is used as name.","severity":"breaking","affected_versions":">=0.1.0"},{"fix":"Add host: '0.0.0.0' to config or pass --host 0.0.0.0 in CLI.","message":"The server binds to 127.0.0.1 (localhost) only by default. To access from other devices, set host to '0.0.0.0'.","severity":"gotcha","affected_versions":">=0.1.0"},{"fix":"Restart the server after changing the password environment variable.","message":"Environment variable SQLITE_DASHBOARD_PASSWORD is read at startup; changing it requires restart.","severity":"gotcha","affected_versions":">=0.1.0"}],"env_vars":null,"search_vec":"'admin':76 'allow':25 'altern':69 'api':52 'base':7 'browser':36,41 'build':61 'commerci':71 'current':23 'dashboard':3,21,88 'data':42 'databas':89 'deploy':85 'design':79 'edit':45 'editor':11,49,91 'environ':67 'file':32 'get':34 'grid':43 'host':15,84 'html/css/js':58 'inlin':44 'javascript':86 'lightweight':81 'like':73 'loos':16 'model':17 'node.js':54 'one':28 'password':64 'plain':57 'point':26 'protect':65 'requir':53 'rest':51 'schema':46 'self':14,83 'self-host':13,82 'ship':55 'sql':48 'sqlite':2,8,31,78,87 'sqlite-dashboard':1 'stabl':24 'step':62 'supabas':20 'support':63 'tabl':40 'tableplus':74 'tool':72 'ui':37 'v0.2.1':22 'variabl':68 'via':66 'viewer':9,47,90 'web':6 'web-bas':5","created_at":"2026-06-07T12:59:58.935256+00:00","updated_at":"2026-06-07T12:59:58.935256+00:00","problems":[{"fix":"npm install better-sqlite3","cause":"Missing optional dependency better-sqlite3 (not auto-installed).","error":"Error: Cannot find module 'better-sqlite3'"},{"fix":"Use a different port via --port or config.port.","cause":"Port 3000 is already in use by another process.","error":"Error: listen EADDRINUSE :::3000"}],"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":"https://github.com/EskelCz/sqlite-dashboard#readme","github":"https://github.com/EskelCz/sqlite-dashboard","docs":null,"changelog":null,"pypi":null,"npm":"sqlite-dashboard","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}}