(Quick Reference)



Uses Hibernate’s SchemaExport tool to generate DDL or export the schema. NOTE: As of Grails 3, the Hibernate plugin is not by default on the build classpath. You need to add it to the build classpath to get the command working.


//Add Hibernate to the build classpath
buildscript {
    dependencies {
        classpath "org.grails.plugins:hibernate:"
grails schema-export
grails schema-export --datasource=lookup
grails prod schema-export
grails dev schema-export
grails prod schema-export export
grails prod schema-export export --datasource=auditing
grails prod schema-export stdout



grails <<environment>> schema-export <<action>> ['stdout'] <<filename>> [--datasource]


  • environment - The environment containing the database configuration to use (dev, prod, etc…​).

  • action - Either 'generate' or 'export'. The default is 'generate'. Specifying 'export' will execute the script against the specified environment’s database instead of just generating the ddl file.

  • stdout - Passing 'stdout' will cause the script to dump the ddl to stdout.

  • filename - The name of the file to write the ddl to. The default is ddl.sql in the project’s 'target' directory.

  • datasource - The DataSource name suffix; defaults to the default DataSource if not specified