DBeaver Installation

Follow the instruction in the second link.

Connection to database server

Turn on VPN, open DBeaver application.
Click the icon of + socket at the top left corner.
Choose the suitable database driver, like MariaDB. Then Next.
Enter your server host, database name, authentication. Then Test Connection.
If connected, press Finish.

View Tables

Go to Database Navigator.
Expand Databases inside ip address.
Right click Tables, to View Tables. View item. SELECT * FROM name.item;

SQL Editor

Run SELECT * FROM namedb.item LIMIT 10;.

SQL Alchemy

Install by


pip3 install sqlalchemy

To connect your database server,


import sqlalchemy as db
import pandas as pd
pd.set_option('display.max_columns', None)
conn_str = f"mysql+pymysql://{Username}:{Password}@{ip_addres+port}/{Database_name}"
with db.create_engine(conn_str).connect() as conn:
    sql = """select * from table1 limit 10 offset 10;"""
    df = pd.read_sql_query(sql,conn)

References