In a nutshell, this website acts as RESTful API, which is connected to a database containing objects that represent cards from the One Piece Trading Card Game. This API covers all current sets and structure decks that are Active on TCG Player for the English Release of the game. (It does not include specialty cards yet,however, I am working on adding them.)
Yes, there are definitely other places where you can get this data.
There are sites like TCG Player, the official One Piece Card Game site, limitlesstcg, and many others that have this same card related data. But I have noticed that some of these sites make it a little complicated to actually pull large amounts of this data in an easy manner. With this site, you would be able to pull a large amount of data all at once, and then use it for whatever you want!
Thus, I thought it would be a fun, and hopefully useful project to work on!
Nowadays, we are storing a good amount of data in the database. We currently store tables for Sets, Structure Deck, and Promo cards, as well as historic pricing tables going up to two weeks in the past.
As for specific card related data, we have card data from sets OP01 - OP12 (including EB01, EB02, PRB01, and PRB02). And we have data from structure decks ST01 - ST28.
In terms of specifics, we store card specific data such as:
So, I know I said I would add Promo cards into the API. They are currently in the database and are able to be pulled via the API. However, there are still a lot of missing images for these cards. This is because there are over 900 unique Promo cards on TCGPlayer that do technically exist and should be tracked. I am slowly working my way through adding images.
It's 100% possible that I may have missed data when performing the gathering and migration processes! If you notice any data that is missing, then please feel free to reach out and message me over Discord so that we can add the missing data!
Here is my discord which you can reach out to: domothebot
There is also a new discord server that I made to make it easier for people to interact and contact me. The following link will let you join the discord server: Join Here!
OPTCG-API was a project I started in July of 2024. Initially, the project started out as making a database for all the card data for the One Piece TCG. I wanted to analyze card colors, card powers, counters, and prices inside the card game over periods of time, and throughout sets.
I initially spent a lot of time manually entering the data from my own cards, as well as by viewing them on the official one piece card game website. This took quite a long time, which then led me to scrape the data from the web, and transform it in a more storable fashion.
With a decently refined database, I thought my project was over. I had built a data pipeline from my web scraping directly into my database, which automatically updated every day. However, I decided I wanted to do more with this data. I started working on a website project using this database, where I would show card data, specifically pricing, over periods of time, and make predictions on how these cards would do in the future via machine learning.
In September of 2024, I decided to turn this website idea into an API. I have used APIs before, and I know how useful they can be for development. Thus, I wanted to make a place where others who want to use the OPTCG card data in applications, can get the data with ease.
In October of 2024, the website had its first release!
In early 2025, I began working on the site again as I felt the UI was a bit ugly and not so user friendly. Thus, I reworked the front end of the site, and included pages to view individual card data.
The entire Front-End of the site was initially built with custom HTML, CSS, and JS. However, when I updated the site in March of 2025, the Front-End was rebuilt with html and Bootstrap 5.
The Back-End of the website was built using Django! (The web scrapers that populate the database daily are in a separate Python project as they were not necessary to have in the web files.) The Django project is connected to a MySQL database, which is where the web scraping and data transformation files store the data. The Django REST Framework is included in the web project, which allows me to expose the data from the database to users. The website itself is hosted on Hostinger, and is paid for monthly by me.
At the moment, there are not many plans to update the tech stack. However, in the future, I could see there being updates made to improve the speed and design of the website.
I will try to be as active as possible when it comes to adding new card sets or structure decks into the database!
For now, the API will have some limits on how much data can be pulled each day, but I will hopefully be able to remove those once the site's position is more stable.
Lastly, my favorite deck is yellow Katakuri! He was my first alt art leader I pulled from a booster box.