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!
Currently, we are storing a small amount of data in our database! We currently store tables for Sets and Structure Deck 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 - OP08 (including EB01). And we have data from structure decks ST01 - ST14.
In terms of specifics, we store card specific data such as:
Eventually, I plan on adding the data for stuff like pre-release cards, and promotion cards. However, that will come with time as I have other things going on in life like work and family.
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
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!
As for the promotion cards, I do not have an exact ETA on when they will be added, but I hope to have it done soon. That way, you all can have your 2 drop Film Bartolomeo or your 4 drop Land of Wano Zoro.
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.