Hey, HN community!<p>We're stoked to launch JupySQL today! JupySQL is an open-source library that brings a modern SQL experience to Jupyter. JupySQL is compatible with all major databases, such as Snowflake, Redshift, PostgreSQL, MySQL, MariaDB, DuckDB, SQL Server, Clickhouse, Trino, and more!<p>To get started, check out our tutorial: <a href="https://jupysql.ploomber.io/en/latest/quick-start.html">https://jupysql.ploomber.io/en/latest/quick-start.html</a><p>SQL is the defacto language for data analysis; however, analysis often requires a mix of SQL and Python. JupySQL bridges this gap, allowing users to execute SQL queries seamlessly in Jupyter and continue their analysis in Python. Add %%sql to the top of your cell and start writing SQL.<p>Here are some of JupySQL's main features:<p>- Syntax highlighting
- Formatting
- Autocompletion
- A GUI for connection management
- Scalable plotting engine
- Integration with pandas and polars
- One-click sharing powered by Ploomber Cloud: <a href="https://ploomber.io">https://ploomber.io</a><p>Documentation: <a href="https://jupysql.ploomber.io">https://jupysql.ploomber.io</a><p>Note that JupySQL is a fork of ipython-sql; which is no longer actively developed. Catherine, ipython-sql's creator, was kind enough to pass the project to us (check out ipython-sql's README).<p>We'd love to learn what you think and what features we can ship for JupySQL to be the best SQL client! Please let us know in the comments!