Database Connections Skill

To set up a JDBC database connection, navigate through the DataPallas UI menus to create a new connection and trigger a schema fetch. The Skill guides you step-by-step through the menu-based connection creation and testing process.

You can discover tables and relationships for SQL report building by reading locally stored schema files generated after connection testing. These artifacts include information schema JSON, table-name listings, domain-grouped schema, and ER diagrams.

Yes, this database connection skill applies to any JDBC-compatible database. It requires UI menu-based connection creation and consumes schema files generated after you successfully test the database connection.

An information schema JSON file is used to improve SQL generation by providing table names, column types, and relationship mappings. This helps produce correct JOINs and map business terms to the right database entities.

You need to refresh the schema before writing SQL queries because schema files must be generated or refreshed after connection testing. This ensures the AI has current table names and information schema details to suggest accurate JOINs and columns.