Database Querying
- Guidelines
- Editing Guidelines
- Visual Novels
- Special Games
- Releases
- Producers
- Staff
- Characters
- Tags & Traits
- Image Flagging
- Capturing Screenshots
- About VNDB
- Discussion Board
- FAQ
- About Us
- Privacy Policy & Licensing
- Database API
- Database Dumps
- Development
1. Introduction
The VNDB database is available for public querying at query.vndb.org.
2. Rules & notes
- You do not need an account to view or run queries, but if you plan to save queries it helps to be logged in on VNDB.
- The database runs on PostgreSQL.
- Queries are run against an import of the near-complete database dump, updated daily at 8:30 UTC. This means that it may take up to 24 hours for changes to the main database to show up in query results.
- Maximum query execution time is 60 seconds (but you may get a timeout before that).
- The database can include additional indices, (materialized) views, stored procedures or other caches that are not available in the original dumps. These are listed in /extras.sql.txt. Feel free to suggest additions to that file in t12800.
- The interface runs SQLPad, bug reports and feature requests may be posted in t12800, but you can also send pull requests directly to the SQLPad repository to give others a chance to provide feedback.
- The database schema will likely change over time and this may break your saved queries.
- The service is provided for humans only. Please DO NOT use bots or crawlers to interface with query.vndb.org, instead use the API or just get the database dumps directly.
- Data obtained through the querying service is available under the Open Database License + Database Contents License, see our Data License for more information.
3. Interesting queries
If you've written a query that may be useful or interesting for others, please share them in t12800. Here's a few:
3.1. Moderation tools
- VNs without releases (sql)
- VNs without developers (sql)
- Unlinked Staff entries (sql)
- Unlinked Staff aliases (sql)
- VN voice actor credits for missing characters (sql)
- Non-Japanese releases with Japanese original title (sql)
- VNs and releases where を/ヲ has been romanized as "wo" (sql)
- Possible misromanization of おう as "oh" for character names (sql)
- Possible misromanization of おう as "oh" for releases (sql)
3.2. Stats
- Number of releases per year (sql)
- Number of new Japanese VNs per year (sql)
- Number of Japanese VNs translated into English per year (sql)
- Number of VNs per language (sql)
- Number of translated OJLVNs per language (sql)
- Number of image flagging votes per day (sql)
- Image voting coverage (sql)
- Screen resolution usage (sql)
- Engine usage (sql)