{"id":18213,"library":"claviz-database-forms","title":"claviz-database-forms","description":"CRUD functionality for PostgreSQL and MSSQL database tables in Claviz. Current stable version: 0.0.13 (March 2025). Release cadence: weekly. Key differentiators: provides no-code tables/forms for database tables, supports autocomplete, XLSX upload, hooks, and styling. Requires external query functions and numeral package.","status":"active","version":"0.0.13","language":"javascript","source_language":"en","source_url":null,"tags":["javascript","claviz-forms"],"install":[{"cmd":"npm install claviz-database-forms","lang":"bash","label":"npm"},{"cmd":"yarn add claviz-database-forms","lang":"bash","label":"yarn"},{"cmd":"pnpm add claviz-database-forms","lang":"bash","label":"pnpm"}],"dependencies":[],"imports":[{"note":"This package is likely a plugin or side-effect module; no explicit exports needed.","wrong":"","symbol":"claviz-database-forms","correct":"import 'claviz-database-forms'"}],"quickstart":{"code":"// Setup: create query functions with specific naming\nasync function executePostgreSqlQuery(query) {\n  // implementation using pg client\n  const result = await client.query(query);\n  return result.rows;\n}\n\nasync function executeMssqlQuery(query) {\n  // implementation using mssql\n  const result = await pool.request().query(query);\n  return result.recordset;\n}\n\n// Then in Claviz UI, assign these functions to tables/forms.\n// Also add clavizAdminUsername and clavizAdminPassword to KeyVault.\n// Required: npm install numeral\n","lang":"javascript","description":"Shows required function setup for PostgreSQL and MSSQL query execution."},"warnings":[{"fix":"Rename functions to include the required substring.","message":"Query functions must contain 'executePostgreSqlQuery' or 'executeMssqlQuery' in their name (case-insensitive).","severity":"gotcha","affected_versions":">=0.0.1"},{"fix":"Update validator functions to match the new signature.","message":"Validator function signature changed: must accept (values, isExisting) parameters.","severity":"gotcha","affected_versions":">=0.0.1"},{"fix":"No fix; behavior change accepted.","message":"XLSX upload preview limited to first 100 rows (since v0.0.12).","severity":"gotcha","affected_versions":">=0.0.12"},{"fix":"Adjust timezone handling in application code.","message":"Date fields are normalized to UTC (since v0.0.3).","severity":"gotcha","affected_versions":">=0.0.3"}],"env_vars":null,"last_verified":"2026-04-25T00:00:00.000Z","next_check":"2026-07-24T00:00:00.000Z","problems":[{"fix":"Update to v0.0.11 or later.","cause":"Numerical values not cast to Numeric type when downloading XLSX.","error":"Error: `format` can only be used on `Date`, `Number` or `\"Formula\"` cells"},{"fix":"Update to v0.0.2 or later.","cause":"Bug in v0.0.1 that omits metadata field.","error":"\"$meta\" missing in dbTable"}],"ecosystem":"npm","meta_description":null,"install_score":null,"install_tag":null,"quickstart_score":null,"quickstart_tag":null}