Skip to main content

Run MySQL, PostgresSQL, SQLite queries with just one line in python. The Ultimate SQL Library.

Project description


Developers are struggling to execute a query and what if you need to execute another query somewhere else? That's a lot of code to rewrite again. You don't have to do this because QuickSQLConnector got you covered!. Quick SQL Connector is a python library that lets you execute MySQL, PostgreSQL, and SQLite queries with just one line of code.

Reducing 80% lines of code and get more done and it's all done in the same syntax with all SQL databases mentioned.

Downloads PyPI version PyPI license Generic badge

Installation 💿


pip install quicksqlconnector


python3 pip install quicksqlconnector

To update Quick SQL Connector to the latest version, add --upgrade flag to the above commands.

Write your first query.

Use 'quicksqlconnector' keyword to import

from quicksqlconnector import quicksqlconnector

Creating instance of module

DB = quicksqlconnector('database','host', port, 'username', 'password')

NOTE : If you're using SQLite, you must provide database file name as follows.

DB = quicksqlconnector('sqlite3', database_name='my_example_database')

For database, it has 3 options (case-sensitive).

  • mysql
  • sqlite3
  • postgres

quicksqlconnector only have one method which is 'query'.


FOR SQLite, you don't need to use parameterized quieries as it is not supported in SQLite.

It has two arguments, query and parameters, parameters are optional.


DB.query("SELECT * FROM test where id= %s", (input_user,))
DB.query("SELECT * FROM test")
DB.query('CREATE TABLE test(name varchar(10), id int(10))')
DB.query("INSERT INTO test values(%s, %s)", ('harry', 13))


DB.query('DROP TABLE movie')
DB.query("CREATE TABLE movie(title varchar(1), year int(1), score int(1))")


DB.query('SELECT datname FROM pg_database')

See for more examples.

🔗Useful Links

Route Link
Buy me a Coffee Visit
Email Visit
PyPi Visit
Website Visit

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

quicksqlconnector-1.5.3.tar.gz (4.0 kB view hashes)

Uploaded source

Built Distribution

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page