Database Dumps

RanobeDB's database is built using PostgreSQL.

These database dumps are generated using pg_dump's plain-text format and then compressed with gzip. You can use psql to restore the database. Once restored, you can connect to your PostgreSQL database and start querying the data.

These dumps contain almost everything in RanobeDB, expect for the following:

• Change histories of database entries
• Anything related to users' lists

RanobeDB also has an API if you prefer programmatic access to our data without downloading the full dump.

Schema

For more information, you can view the full schema on Github.

Since the database dumps do not contain everything on RanobeDB, you can ignore the tables in the above schema that aren't included in the dumps.
The database dumps are not stable APIs. The schema may change over time.

License

RanobeDB is made available under the Open Database License. Any rights in individual contents of the database are licensed under the Database Contents License.

Download

The database dumps are created once a day at 12:00 AM UTC+00:00.

Download the database: rndb-db-public-latest.dump.gz

The past 7 days of database dumps are also available with the following link format:
https://dumps.ranobedb.org/rndb-db-public-{2025-01-01}.dump.gz