{"library":"ipython-sql","type":"library","category":null,"description":"ipython-sql provides SQL magic commands (`%sql` and `%%sql`) to seamlessly integrate SQL queries and database interactions directly within IPython and Jupyter Notebook environments. It leverages SQLAlchemy for database connections and supports various RDBMS. The current version is 0.5.0. Development has largely shifted to its successor, JupySQL, making ipython-sql a legacy project primarily in maintenance mode.","language":"python","status":"maintenance","version":"0.5.0","tags":["ipython","jupyter","sql","database","orm","magic","data-science","data-analysis"],"last_verified":"Sat May 23","install":[{"cmd":"pip install ipython-sql","imports":["%load_ext sql","%sql sqlite:///:memory:","%%sql\nSELECT * FROM my_table;"]},{"cmd":"pip install ipython-sql [postgresql]","imports":[]},{"cmd":"pip install ipython-sql [mysql]","imports":[]},{"cmd":"pip install ipython-sql [duckdb]","imports":[]}],"homepage":null,"github":"https://github.com/catherinedevlin/ipython-sql","docs":null,"changelog":null,"pypi":"https://pypi.org/project/ipython-sql/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"3.10–3.9","success_rate":25,"avg_install_s":6.7,"avg_import_s":null,"wheel_type":"wheel"},"url":"https://checklist.day/v1/registry/ipython-sql/compatibility"}}