llama-index-coresqlalchemypsycopg2OpenAIintermediate30 min

LlamaIndex + PostgreSQL structured data agent

Natural language querying of PostgreSQL structured data in AI agents via text-to-SQL.

Prerequisites

  • PostgreSQL DB with pgvector extension
  • Python libs: llama-index-core
  • sqlalchemy
  • psycopg2-binary
  • OpenAI API key
  • SQLAlchemy connection string.

Further reading