{"library":"sqlalchemy-rdsiam","title":"SQLAlchemy IAM Auth for RDS","type":"library","description":"SQLAlchemy dialects for connecting to Amazon RDS instances using IAM database authentication. Requires boto3 and SQLAlchemy. Version 1.0.3 (latest), maintains compatibility with Python 3.6+. Low release cadence, currently maintained by Cisco.","language":"python","status":"active","last_verified":"Fri May 01","install":{"commands":["pip install sqlalchemy-rdsiam"],"cli":null},"imports":["from sqlalchemy import create_engine"],"auth":{"required":false,"env_vars":[]},"links":{"homepage":null,"github":"https://github.com/cisco-open/sqlalchemy-rdsiam","docs":null,"changelog":null,"pypi":"https://pypi.org/project/sqlalchemy-rdsiam/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null},"quickstart":{"code":"import os\nfrom sqlalchemy import create_engine\n\nengine = create_engine(\n    \"postgresql+iam://dbuser@host:5432/mydb\",\n    connect_args={\n        \"aws_access_key_id\": os.environ.get('AWS_ACCESS_KEY_ID',''),\n        \"aws_secret_access_key\": os.environ.get('AWS_SECRET_ACCESS_KEY',''),\n        \"region\": \"us-east-1\"\n    }\n)\n# Example query\nwith engine.connect() as conn:\n    result = conn.execute(\"SELECT 1\")\n    print(result.fetchone())","lang":"python","description":"Connect to RDS PostgreSQL with IAM auth using the 'postgresql+iam' dialect.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}