[Go to site: main page, start]

Python Oracle

Open-source Python projects categorized as Oracle

Top 15 Python Oracle Projects

  1. Archery

    SQL 审核查询平台 (by hhyo)

    Project mention: archery-cli: Connect AI Tools to Your SQL Audit Platform | dev.to | 2026-04-27

    At my company, we use Archery for SQL audit and read-only queries against our databases.

  2. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
  3. sqlit

    A user friendly TUI for SQL databases. Written in python. Supports SQL server, Mysql, PostreSQL, SQLite, Turso and more.

    Project mention: Sqlit – A lazygit-style TUI for SQL databases | news.ycombinator.com | 2026-05-25

    - Themes (Rose Pine, Tokyo Night, Nord, Gruvbox).

    Install: `pipx install sqlit-tui` (also works with `uv tool install` and `pip`).

    Built with Python and Textual. First shared here in December (https://news.ycombinator.com/item?id=46276002) - a lot has shipped since.

    Repo: https://github.com/Maxteabag/sqlit

    Feedback welcome, especially on what's still missing for daily-driver use.

    My goal is to make an aesthetic tool that makes it easy and enjoyable to connect and query data, and do that one thing only, really well.

  4. PonyORM

    Pony Object Relational Mapper

  5. fapro

    Fake Protocol Server

  6. python-oracledb

    Python driver for Oracle Database conforming to the Python DB API 2.0 specification with many advanced features. Fast, small, portable. Enterprise ready.

  7. SmartDB_MCP

    Universal database MCP server connecting to MySQL, PostgreSQL, SQL Server, MariaDB,DM8,Oracle,not only provides basic database connection such as OAuth 2.0 authentication , health checks, SQL optimization, and index health detection

    Project mention: Universal database MCP server for MySQL, PostgreSQL, SQL Server, MariaDB,Oracle | dev.to | 2025-08-26

    You may visit this Github link: https://github.com/wenb1n-dev/SmartDB_MCP

  8. sqlspec

    A Query Mapper for Python

  9. data-profiling

    a set of scripts to pull meta data and data profiling metrics from relational database systems

  10. dbt-oracle

    dbt (data build tool) adapter for Oracle Autonomous AI Database (by oracle)

  11. DiLuConverter

    A powerful Excel import and export tool that supports MySQL, Oracle, SQL Server, PostgreSQL and more popular databases

  12. gpa

    GPA++ course stats search engine

  13. extensionmigrationassistant

    Detect Lock-in Extension wrapper introduce as part of conversion tool and provides automated way to remove it.

  14. btc-market-data-oracle

    Prepaid BTC market snapshots for autonomous trading agents (spot, perps, arbitrage). Low-latency API + budgeted verifications.

    Project mention: A real-time btc-market-data-oracle for Trading Agents/bots | news.ycombinator.com | 2026-03-23

    Hi devs! I hope you're all doing well. Just wanted to know if there are few Trading Agents/Bots devs operators here that focuses solely on BTC. I've been working on a btc-market-data-oracle that delivers real-time btc market data for trading agents/bots with almost no latency (because it's a prepaid system; your Agent doesn't have to pay an invoice for every market data request, which reduces friction). All you need is a NWC capable Agent. Looking forward to know some trading agent devs. The Oracle Autopilot (NWC Plug & Play) setup is here: https://github.com/Mike-io-hash/btc-market-data-oracle/tree/...

    It's a fully operational and hosted service that runs like a sidecar to the Agent, so you don't have to touch any core code of your agent.

  15. mcp-oracle-dba

    Model Context Protocol server for Oracle Database - read-only, audited, SQL-guarded. Let Claude Desktop query Oracle safely.

    Project mention: An Oracle DBA builds AI: shipping Oracle 23ai RAG and an MCP server in a weekend | dev.to | 2026-05-13

    That's the demo screenshot at the top of mcp-oracle-dba, one of two open-source repos I shipped this weekend as an Oracle Apps DBA learning AI infrastructure. The other is oracle-ebs-rag — a retrieval-augmented chat assistant over Oracle E-Business Suite resolution notes, running on Oracle Database 23ai's native vector search.

  16. dpyc-oracle

    DPYC Honor Chain community concierge — free MCP service answering membership, governance, and onboarding questions

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

Python Oracle discussion

Log in or Post with

Python Oracle related posts

  • OracleDB anyone?

    1 project | /r/Papermerge | 2 Mar 2023
  • How would you connect to an Oracle database that's hosted on a on premise server?

    1 project | /r/learnpython | 25 Oct 2022
  • Open Source at Illinois has released Cherry!

    1 project | /r/UIUC | 9 Mar 2022

Index

What are some of the best open-source Oracle projects in Python? This list will help you:

# Project Stars
1 Archery 6,871
2 sqlit 4,317
3 PonyORM 3,823
4 fapro 1,608
5 python-oracledb 441
6 SmartDB_MCP 85
7 sqlspec 83
8 data-profiling 77
9 dbt-oracle 66
10 DiLuConverter 47
11 gpa 13
12 extensionmigrationassistant 3
13 btc-market-data-oracle 1
14 mcp-oracle-dba 0
15 dpyc-oracle 0

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com