{"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,"search_vec":"'0.0.13':18 '2025':20 'autocomplet':35 'cadenc':22 'claviz':2,14,50 'claviz-database-form':1 'claviz-form':49 'code':29 'crud':5 'current':15 'databas':3,11,32 'differenti':25 'extern':42 'form':4,51 'function':6,44 'hook':38 'javascript':48 'key':24 'march':19 'mssql':10 'no-cod':27 'numer':46 'packag':47 'postgresql':8 'provid':26 'queri':43 'releas':21 'requir':41 'stabl':16 'style':40 'support':34 'tabl':12,33 'tables/forms':30 'upload':37 'version':17 'week':23 'xlsx':36","created_at":"2026-04-25T07:37:04.765120+00:00","updated_at":"2026-04-25T07:37:04.765120+00:00","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,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":"","cli_version":null,"type":"library","homepage":null,"github":null,"docs":null,"changelog":null,"pypi":null,"npm":"https://www.npmjs.com/package/claviz-database-forms","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database","web-framework"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-17","next_check":"2026-07-24","install_tag":null}}