Start with this repository if you want to use the Python SQLAlchemy package to interact with a DuckDB database as well as the SQLTools VS Code extension as a visual UI for that database.
https://duckdb.org/docs/extensions/overview https://duckdb.org/docs/extensions/sqlite.html https://duckdb.org/docs/extensions/postgres
Can use Harlequin to connect to DuckDb: https://harlequin.sh/docs/duckdb/index