Connect to multiple databases, make or generate SQL queries, analyze or visualize.

Source: https://github.com/HimrajDas/SQTHON

SQTHON

Connect to multiple databases, run raw SQL queries, perform analysis and make visualization.

Currently working on:

• SqthonAI: generate SQL queries using a LLM of your choice ?
• Security improvements?
• New Features
• custom exception for better error showcase ?

Package is not published to pypi yet and is being made using poetry. ?

Currently, this package will work on windows only.

And for your safety create a virtual environment.?

Installation ?

1. Clone the repository.

https://github.com/HimrajDas/SQTHON.git

cd sqthon

2. Install poetry (if not installed)

Using Windows powershell

(Invoke-WebRequest -Uri https://install.python-poetry.org -UseBasicParsing).Content | py -

Using Linux, macOS, Windows (WSL)

curl -sSL https://install.python-poetry.org | python3 -

Using pipx

pipx install poetry

3. Install dependencies using poetry

poetry install

Alternative install ?

pip install git https://github.com/HimrajDas/SQTHON

Now how do I use it?

1. Create a .env file in your project root. [a must-do step]

• set database passwords like this: password ✅

2. Let's connect to a database.

from sqthon import Sqthon
# Instantiate the class. Passwords gets fetch from the .env file (that's why you have to create it)
sq = Sqthon(dialect="mysql", user="root", host="localhost", service_instance_name="MySQL service instance name")

# Connects to a database
conn1 = sq.connect_to_database(database="dbname", local_infile=True) # local_infile controls the infile settings for the client.
conn2 = sq.connect_to_database("dbname")

# or you can connect like this:
conn3 = sq.connect_db.connect(database="dbname") # not preferred ❌.

If your MySQL server is not running then providing service_instance_name will start the server automatically.
If you are not running the script as an administrator, it will ask for admin privilege to start the server.

3. Queries. ⭐

Suppose you have a database named dummy ?

Connect to the database.

dummy_conn = sq.connect_to_database(database="dummy")

Now, how do I run some queries?

# Suppose, You have a table named sales in the dummy database.
query = """
SELECT customer_name FROM sales;
"""

customer_names = dummy_conn.run_query(query=query) # it will return the result as pandas dataframe.

run_query have several params other than query, they are: visualize: bool = False,
plot_type: str = None,
x=None,
y=None,
title=None.
If you make visualize=True and provide x, y and plot_type args then it will return a graph along with
the data which I don't think is good for later use of the variable.

4. Visualization.

https://github.com/HimrajDas/SQTHON.git

5. Importing CSV to a Table.

I have isolated this feature for several security reasons. What do I mean is that it uses a separate
engine to import the csv to a table which you don't need to worry about ?

It exists in the util.py as a separate method devoid of life from others.
Currently it supports mysql only.

Method Name: import_csv_to_mysqltable

Params it has:

• user: str
• host: str
• database: str
• csv_path: str
• service_instance: str = None
• table: str

user: username,
host: host,
database: database name,
csv_path: relative or absolute path to the csv file.

table: table name, if it doesn't exist then it will create the table according to the csv file.
You don't need to worry about data types. It will handle it.

cd sqthon

The above is the detailed content of Connect to multiple databases, make or generate SQL queries, analyze or visualize.. For more information, please follow other related articles on the PHP Chinese website!