As Greg says, you can add database SQL upgrade scripts in a module, but we don't support adding database SQL scripts for an assay type.

You don't need to write PostgreSQL and SqlServer scripts if you only intend to support one. To indicate that your module only will run on a particular database, add "SupportedDatabases: pgsql" or "SupportedDatabases: mssql" to your module.properties file.