TonyRo wrote on 06/22/26 at 12:43:39:

I don't think there was a misunderstanding. What I was suggesting is that you don't have to use lichess as a (web-based) GUI in order to access whatever statistics you want. Scid has the same statistics done better.

And let's not conflate the data with the database management system. Those are two separate things. The same goes for the ChessBase database (the GUI) and the ChessBase database (the games). People use the same name for two different things, but you can get the second without getting the first. Personally I love the ChessBase database (the games), but am not impressed by the ChessBase database (the GUI).

The lichess database can be downloaded. If that's a bit much, it can be filtered first by rating and time control, and then downloaded. Open the lichess database in Scid (but see edit below), if that's what you want. Not sure why anybody is interested in the lichess database, it looks like a mountain of dung to me, but if you want it Scid can handle it.

Now what you can do in Scid. Open the tree window for the downloaded lichess database. Open the tree window for your "mygames" database. Two tree windows at once. (If you have multiple monitors, you can knock yourself out opening tree windows on other databases.) Step through a game, and for every move you can see statistics for every candidate in the lichess database matched up against statistics for every candidate in mygames. That beats the pants off going over a game in a lichess study.

What Scid can't do is filter the database and have the tree window show statistics for only the filtered games, on the fly, like lichess can do. The tree window always shows statistics for the full database. But there is an easy work-around. Drag the filtered games to the clipbase, and open the tree window on the clipbase. If you want to change the filter, do that in the original database, empty the clipbase, and drag the newly filtered games to the clipbase.

Edited:

an ordinary chessplayer wrote on 06/21/26 at 01:17:54:

Just to be clear here, since I suspect there was a misunderstanding - I believe John was suggesting lichess here for the actual lichess database, which is the database of all games played on lichess, filterable by rating and time control. This allows you to map out what opening lines and moves are actually popular at your level relative to what a typical reference DB (Megabase, Caissabase, the lichess Masters DB, etc) would say. It varies wildly across rating ranges, and so the latter databases can be a bit misleading. 

I have been working on an open-source, cross-platform alternative to SCID for many months now, I'm calling it Tabiya. In a few months I'm hoping to open it up to beta testers. Anyone reading this that's interested, shoot me a PM and I'll reach back out when the time comes. I have used Chessbase and SCID quite a bit over the years, but find Chessbase to be massively bloated, whilst SCID looks a bit old and can be slightly cumbersome. Tabiya is designed to hopefully be in the sweet spot - looks a bit more modern and does only what I'd consider to be critical and useful for most people trying to improve at chess. It uses Chessground and the color schemes are similar to lichess light/dark mode, so if you like the way lichess looks, you'll probably  like using it. It is already quite far along, and you can do almost everything you'd ever need to, e.g. all the standard databases operations (creating, merging, deleting, backing up, rearranging), analyzing games with engines, accessing opening explorer stats for lichess DBs and a user-chosen reference DB, filtering databases by metadata, positions, position fragments, or what I call "fuzzy" positions (same piece tallies, similar pawn structures). You can spar against the Maia bot at whatever rating is useful to you, and I incorporated an opening book so it plays the exact ratings in the exact proportions for players at that rating. Lastly, you can create puzzle sets yourself or import them from lichess and use the Woodpecker Method, and it automatically tracks all your stats for you so you can see your improvement as you go!

Bare ChessBase + 30 euros to Mark Crowther at TWIC for his complete database back to 1993 + Stockfish 18. Add Leela if your computer has a fast / modern GPU.

Opening study: start in Lichess studies to access their statistics (find moves actually played at your level) and then transfer pgns to Chessbase for long-term storage and access.

Mygames: a database of your games with your notes.