{"library":"sqlalchemy-ibmi","title":"SQLAlchemy IBM i (Db2)","type":"library","description":"Provides SQLAlchemy dialects for Db2 on IBM i (AS/400), enabling ORM and core SQL access. Current version 0.9.3, supporting Python >=3.6.2. Maintained as part of the IBM i open source ecosystem.","language":"python","status":"active","last_verified":"Mon Apr 27","install":{"commands":["pip install sqlalchemy-ibmi"],"cli":null},"imports":["from sqlalchemy import create_engine\nengine = create_engine('ibmi://user:password@host/database')"],"auth":{"required":false,"env_vars":[]},"links":{"homepage":null,"github":null,"docs":null,"changelog":null,"pypi":"https://pypi.org/project/sqlalchemy-ibmi/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null},"quickstart":{"code":"from sqlalchemy import create_engine\nengine = create_engine('ibmi://user:password@host/database')\nwith engine.connect() as conn:\n    result = conn.execute(\"SELECT * FROM SYSIBM.SYSDUMMY1\")\n    print(result.fetchone())","lang":"python","description":"Minimal working example: connect to IBM i via ibmi:// URL and run a query.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}