{"id":28210,"library":"spotify-to-sqlite","title":"spotify-to-sqlite","description":"Converts a Spotify export ZIP file into a SQLite database. Current version 0.2.1, released Jun 2023. Low activity, maintained as needed.","status":"active","version":"0.2.1","language":"python","source_language":"en","source_url":"https://github.com/chekos/spotify-to-sqlite","tags":["spotify","sqlite","data-export","cli"],"install":[{"cmd":"pip install spotify-to-sqlite","lang":"bash","label":"PyPI install"}],"dependencies":[{"reason":"CLI framework","package":"click","optional":false},{"reason":"SQLite database creation","package":"sqlite_utils","optional":false},{"reason":"Spotify Web API calls","package":"spotipy","optional":false}],"imports":[{"note":"Top-level module; no common wrong import.","symbol":"spotify_to_sqlite","correct":"import spotify_to_sqlite"}],"quickstart":{"code":"# Convert a Spotify export zip to SQLite\ndb_path = 'spotify.db'\n# Run CLI command: spotify-to-sqlite convert my_spotify_data.zip spotify.db\nimport subprocess\nsubprocess.run(['spotify-to-sqlite', 'convert', 'my_spotify_data.zip', db_path])\n# Or use with audio features:\n# spotify-to-sqlite convert my_spotify_data.zip spotify.db --audio-features\n","lang":"python","description":"Basic usage via subprocess; CLI converts export to database."},"warnings":[{"fix":"Use the `convert` subcommand: `spotify-to-sqlite convert <input> <output>`","message":"The default command changed from `spotify-to-sqlite my_spotify_data.zip spotify.db` to `spotify-to-sqlite convert my_spotify_data.zip spotify.db` in v0.2.","severity":"breaking","affected_versions":"0.2+"},{"fix":"To overwrite an existing database, use `--recreate`.","message":"The `--recreate` flag in v0.1.1+ replaces the old default of overwriting the database. Not a breaking change but behavior differs from v0.1.","severity":"deprecated","affected_versions":">=0.1.1"},{"fix":"Set environment variables SPOTIPY_CLIENT_ID and SPOTIPY_CLIENT_SECRET before running with `--audio-features`.","message":"Audio features require Spotify API credentials (SPOTIPY_CLIENT_ID, SPOTIPY_CLIENT_SECRET). Without them, `--audio-features` fails silently or errors.","severity":"gotcha","affected_versions":">=0.1.1"}],"env_vars":null,"last_verified":"2026-05-09T00:00:00.000Z","next_check":"2026-08-07T00:00:00.000Z","problems":[{"fix":"Upgrade to spotify-to-sqlite>=0.2 with `pip install --upgrade spotify-to-sqlite`.","cause":"User has an old version (<0.2) and tries `convert` subcommand.","error":"Usage: spotify-to-sqlite [OPTIONS] COMMAND [ARGS]...\nTry 'spotify-to-sqlite --help' for help.\nError: No such command 'convert'."},{"fix":"Verify the ZIP file path and ensure it's a valid Spotify data export.","cause":"Missing or malformed ZIP file; often happens when file path is incorrect.","error":"TypeError: 'NoneType' object is not subscriptable"},{"fix":"Set environment variables: SPOTIPY_CLIENT_ID='your_id' SPOTIPY_CLIENT_SECRET='your_secret'.","cause":"Missing SPOTIPY_CLIENT_ID or SPOTIPY_CLIENT_SECRET environment variables when using --audio-features.","error":"spotipy.oauth2.SpotifyOauthError: You need to set your Spotify API credentials."}],"ecosystem":"pypi","meta_description":null,"install_score":null,"install_tag":null,"quickstart_score":null,"quickstart_tag":null}