Skip to content

junko012/pokemon-database

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Exxeguttor Pokemon Database

A portable SQLite Pokémon database designed for the Exxeguttor ecosystem and third-party applications.

Overview

Exxeguttor Pokemon Database is a consolidated Pokémon knowledge base generated from multiple public data sources and normalized into a single SQLite database.

The project was created to provide a fast, offline, language-independent data layer for:

  • Desktop applications
  • Web APIs
  • AI systems
  • Research projects
  • Companion applications
  • PKHeX integrations
  • Data analysis tools

The database is distributed as a single SQLite file:

pokemon.db

and can be consumed from any platform that supports SQLite.


Release Information

Current Release:

v1.0.0

Database File:

pokemon.db

Database Size:

~46 MB

Dataset Statistics

Table Records
Species 1350
Moves 937
Abilities 371
Items 1200
Learnsets 681289
Evolution Chains 484
Evolution Conditions 3294
Type Effectiveness 128

Repository Structure

exxeguttor-pokemon-database
│
├── database
│   └── pokemon.db
│
├── resources
│   └── movesets_all_combined.json
│
├── docs
│   ├── SCHEMA_REFERENCE.md
│   ├── POKEMON_DB_REFERENCE.md
│   ├── DATA_SOURCES.md
│   └── ERD.png
│
├── CHANGELOG.md
├── CONTRIBUTING.md
├── ROADMAP.md
├── LICENSE
└── README.md

Database Contents

Species

Stores Pokémon species metadata and base stats.

Includes:

  • Physical characteristics
  • Growth rate
  • Capture rate
  • Base experience
  • Gender rate
  • Base battle statistics

Species Types

Stores primary and secondary typings.

Example:

Bulbasaur
├─ Grass
└─ Poison

Species Abilities

Stores normal and hidden abilities.


Moves

Stores move metadata.

Includes:

  • Type
  • Power
  • Accuracy
  • PP
  • Priority
  • Target
  • Effect descriptions

Abilities

Stores ability metadata and descriptions.


Items

Stores item metadata.

Includes:

  • Category
  • Cost
  • Fling data
  • Descriptions

Type Effectiveness

Stores battle effectiveness multipliers.

Example:

Fire → Grass = 2.0
Electric → Ground = 0.0
Water → Fire = 2.0

Games

Stores supported game identifiers.

Examples:

redgreen
yellow
emerald
platinum
blackwhite
scarletviolet

Learnsets

Stores move acquisition information per game.

Supports:

  • Level-up moves
  • TM/HM moves
  • Tutor moves
  • Egg moves
  • Event moves
  • Evolution moves

Current records:

681,289

Evolution Chains

Stores evolutionary relationships.

Example:

Bulbasaur
 └─ Ivysaur
     └─ Venusaur

Evolution Conditions

Stores evolution requirements.

Examples:

Level
Item
Trade
Friendship
Time of Day
Known Move
Location
Weather

External Resources

The following resource is intentionally distributed outside the SQLite database:

movesets_all_combined.json

Reason:

  • Large file size
  • Independent update cycle
  • Competitive data changes frequently
  • Optional consumption by client applications

Applications may load this resource separately when advanced moveset recommendations are required.


Design Goals

  • Portable
  • Offline-first
  • SQLite-native
  • Language independent
  • Fast local queries
  • Easy integration
  • Stable identifiers
  • Minimal duplication

Generation

This database is generated using:

Exxeguttor.DataBuilder

which transforms and normalizes Pokémon data into a relational SQLite structure.


Documentation

Additional documentation can be found in:

docs/

Including:

  • SCHEMA_REFERENCE.md
  • POKEMON_DB_REFERENCE.md
  • DATA_SOURCES.md
  • ERD.png

Intended Usage

This database may be used in:

  • Personal projects
  • Open source software
  • Commercial software
  • Research projects
  • Educational tools
  • AI systems

subject to the terms of the MIT License.


Legal Notice

Pokémon and all related names, characters, species, moves, abilities, items, games, trademarks, and intellectual property are owned by Nintendo, Game Freak, and The Pokémon Company.

Exxeguttor Pokemon Database is an independent project and is not affiliated with, endorsed by, or sponsored by Nintendo, Game Freak, The Pokémon Company, or the PKHeX project.


License

MIT License

See the LICENSE file for details.

About

a useful pokémon database in SQLite used by Exxeguttor, the linux-native pokemon save files editor.

Topics

Resources

License

Contributing

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors