Skip to content
masterclass Buddy
Start learning

Pandas · Function

pd.read_sql

Reads a SQL query or database table into a pandas DataFrame. It supports several connection types and can also return the result in chunks.

Last updated

Since
2.2.0 for ADBC driver support

Syntax

pandas.read_sql(sql, con, index_col=None, coerce_float=True, params=None, parse_dates=None, columns=None, chunksize=None, dtype_backend=<no_default>, dtype=None)

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

Subscribe
  • read_sql_table
  • read_sql_query

Source: pandas.read_sql — pandas 3.1.0 documentation. Checked 2026-11-03.