ORMs, Databases & Migrations

This category includes tools for interacting with databases, managing schemas, and supporting SQL or NoSQL storage. They're often used alongside AI tools for storing vector embeddings, predictions, logs, and user inputs.

Tools:

• SQLAlchemy – The most popular ORM in Python, offering database models, session management, and raw SQL execution. Works with PostgreSQL, SQLite, MySQL, and more.

• Alembic – A lightweight database migration tool for SQLAlchemy. Enables versioning of schema changes for development and production sync.

• Databases – An async database interface for Python, works well with FastAPI and SQLAlchemy. Allows safe non-blocking DB queries.

• Vector Databases – Refers to Python-compatible APIs for tools like Pinecone, Qdrant, Chroma, and Weaviate. Useful for semantic search and LLM context storage.