• 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
• Database Querying
• 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 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)

3.3. Custom querying

• Fully translated VNs of a given developer
• Advanced VN search