Showing 22 open source projects for "sql queries"

View related business solutions
  • Cut Data Warehouse Costs by 54% Icon
    Cut Data Warehouse Costs by 54%

    Easily migrate from Snowflake, Redshift, or Databricks with free tools.

    BigQuery delivers 54% lower TCO with exabyte scale and flexible pricing. Free migration tools handle the SQL translation automatically.
    Try Free
  • Fully Managed MySQL, PostgreSQL, and SQL Server Icon
    Fully Managed MySQL, PostgreSQL, and SQL Server

    Automatic backups, patching, replication, and failover. Focus on your app, not your database.

    Cloud SQL handles your database ops end to end, so you can focus on your app.
    Try Free
  • 1
    SQL Explorer

    SQL Explorer

    Easily share data across your company via SQL queries

    SQL Explorer aims to make the flow of data between people fast, simple, and confusion-free. It is a Django-based application that you can add to an existing Django site, or use as a standalone business intelligence tool. Quickly write and share SQL queries in a simple, usable SQL editor, preview the results in the browser, share links, download CSV, JSON, or Excel files (and even expose queries as API endpoints, if desired), and keep the information flowing! ...
    Downloads: 2 This Week
    Last Update:
    See Project
  • 2
    athenaSQL

    athenaSQL

    SQL builder for AWS Athena, inspired by sparkSQL

    athenaSQL is Athena SQL query builder, inspired by sparkSQL. It borrow some sparkSQL’s concept sparkSQL. It was initially designed to eliminate the need for hard-coding SQL queries as strings within Python scripts and as an alternative to any bespoke SQL query templating. However, it offers the flexibility to be used in various ways as needed.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 3
    mycli

    mycli

    CLI for MySQL with auto-completion and syntax highlighting

    mycli is an enhanced command-line client for MySQL and MariaDB that features syntax highlighting and intelligent auto-completion for database queries. Built for developers and DBAs, it improves productivity with features like query history, table suggestions, and colored output. The tool is designed to be both powerful and user-friendly, making interactive database work more efficient and visually intuitive.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 4
    sqlite-web

    sqlite-web

    Web-based SQLite database browser written in Python

    ...It lets users open existing SQLite databases or create new ones through a browser interface. The tool can browse table data, inspect database structure, and run arbitrary SQL queries from a dedicated query tab. It also supports common editing actions, including inserting, updating, and deleting rows. Users can add or drop tables, columns, and indexes, and they can import or export data in JSON or CSV format. It can run from the command line, through Docker, or with a higher-performance gevent WSGI server, making it useful for quick database inspection, lightweight administration, and local development workflows.
    Downloads: 0 This Week
    Last Update:
    See Project
  • Build Agents and Models on One Platform Icon
    Build Agents and Models on One Platform

    Everything you need to build production-ready agents and models. Access 200+ Google and third-party AI models and tools.

    Gemini Enterprise Agent Platform is Google Cloud's comprehensive platform for developers to build, scale, govern, and optimize agents and models. Choose from Google's most advanced models and third-party models like Anthropic's Claude Model Family.
    Try It Free
  • 5
    SQLAlchemy

    SQLAlchemy

    The Database Toolkit for Python

    ...A relationally-oriented query system, exposing the full range of SQL's capabilities explicitly, including joins, subqueries, correlation, and most everything else, in terms of the object model. Writing queries with the ORM uses the same techniques of relational composition you use when writing SQL.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 6
    Grafana

    Grafana

    Leading open-source visualization and observability platform

    Grafana OSS is the leading open-source platform for visualization and observability. It enables teams to query, visualize, alert on, and explore telemetry data from multiple sources in a single interface. With support for 100+ data source plugins—including Prometheus, Loki, Elasticsearch, InfluxDB, SQL/NoSQL databases, and OpenTelemetry—Grafana helps teams correlate metrics, logs, and traces across applications and infrastructure. Users can build interactive dashboards with rich...
    Downloads: 14 This Week
    Last Update:
    See Project
  • 7
    Ibis

    Ibis

    Expressive analytics in Python at any scale

    ...You don't need to sacrifice maintainability to get to those insights! Ibis builds on top of and works with existing Python tools. Ibis provides a full-featured replacement for SQL SELECT queries, but expressed with Python code. All tables in Ibis are immutable. To select a subset of a table's columns, or to add new columns, you must produce a new table by means of a projection. If you pass a function instead of a string or Ibis expression in any projection context, it will be invoked with the "parent" table as its argument. ...
    Downloads: 0 This Week
    Last Update:
    See Project
  • 8
    EdgeDB

    EdgeDB

    A next-generation graph-relational database

    The world's favorite graph-relational database is back for an action-packed sequel. Tune in for a series of lightning talks breaking down what's new and what's next for EdgeDB. EdgeDB is an open-source database designed as a spiritual successor to SQL and the relational paradigm. It aims to solve some hard design problems that make existing databases unnecessarily onerous to use. Powered by the Postgres query engine under the hood, EdgeDB thinks about schema the same way you do: as objects...
    Downloads: 0 This Week
    Last Update:
    See Project
  • 9

    pyDaSSQLiteMan

    An easy way to manage SQLite databases and query CSV files

    Welcome to the project page for pyDaSSQLiteMan (Python Data and SQLite Manager). This application is a Python Tkinter application designed to enable easy SQLite database file manipulation, and an easy method to run SQL styled queries on CSV files. If you're not downloading the pre-compiled executable you will need Python to run this app. You can download it from http://www.python.org/ . I'd recommend something after version 3. Testing has been Windows based. SQLite is a free database format released into the public domain. See http://www.sqlite.org/ Please check out the Wiki Home page https://sourceforge.net/p/pycsvdb/wiki/Home/ and the General Help page (https://sourceforge.net/p/pycsvdb/wiki/General%20Help/) to find extra information and help. ...
    Downloads: 0 This Week
    Last Update:
    See Project
  • Go from Code to Production URL in Seconds Icon
    Go from Code to Production URL in Seconds

    Cloud Run deploys apps in any language instantly. Scales to zero. Pay only when code runs.

    Skip the Kubernetes configs. Cloud Run handles HTTPS, scaling, and infrastructure automatically. Two million requests free per month.
    Try it free
  • 10
    GraphQLmap

    GraphQLmap

    GraphQLmap is a scripting engine to interact with endpoints

    ...For a pentester, GraphQLmap speeds up discovery and exploitation workflows: you don’t just test known endpoints—you enumerate schema, fuzz fields, and chain queries. It offers a CLI, supports various HTTP methods, custom headers, proxies, and is designed to work with real-world GraphQL deployments.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 11
    mssql-cli

    mssql-cli

    A command-line client for SQL Server with auto-completion

    mssql-cli is an interactive command line query tool for SQL Server. This open-source tool works cross-platform and is proud to be a part of the dbcli community. mssql-cli supports a rich interactive command line experience, with features such as auto-completion, fewer keystrokes needed to complete complicated queries. Syntax highlighting, highlights T-SQL keywords. Query history, easily complete an auto-suggested query that was previously executed.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 12
    QAL

    QAL

    Query Abstraction Layer

    Project has moved to: https://github.com/OptimalBPM/qal QAL is a collection of libraries for mining, transforming and writing data from and to a number of places. Sources and destinations include different SQL and NoSQL backends, file formats like .csv, XML and excel. Even untidy HTML web pages. It has a database abstraction layer that supports connectivity to Postgres, MySQL, DB2, Oracle, MS SQL server. JSON and MongoDB is coming. It uses XML/JSON formats(self-generated SQL schemas) for representing queries, transformation and merging, making it scriptable. ...
    Downloads: 0 This Week
    Last Update:
    See Project
  • 13
    PySQL aims to be a full replacement for sqlplus (and much more). It has features such as history, completion, explain plan, session list, background queries, datamodel graphical output, object dependencies, PL/SQL package function call tree...
    Downloads: 37 This Week
    Last Update:
    See Project
  • 14
    Db Api client is a simple Python DB Api v2.0 client. It shows some information about database, tables, table\'s description. Db Api Client provides sql queries executing, shows results, and exports to some formats (html, csv).
    Downloads: 0 This Week
    Last Update:
    See Project
  • 15
    Musiql is a command-line frontend to MPlayer that stores track and playlist information in an SQLite database and allows access to this database through SQL queries entered on the command line.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 16
    PgWorksheet is a simple GUI frontend to PostgreSQL for executing SQL queries and psql commands without using the psql command line tool. Please see the project home page for bug reports, forums and installation instructions.
    Downloads: 47 This Week
    Last Update:
    See Project
  • 17
    ShelveDB is a pure python SQL-like database engine, where queries are preformed in analogous python syntax. It uses only built-in modules and shelve as the data structure. It has regular expression searching, plus native python typing and type checking.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 18
    PONY - ORM & web publication framework

    PONY - ORM & web publication framework

    Pony is a fast and easy to use Python ORM

    Pony is an object-relational mapper. The most interesting feature of Pony is its ability to write queries to the database using generator expressions. Pony works with entities which are mapped to a SQL database. Using generator syntax for writing queries allows the user to formulate very eloquent queries. It increases the level of abstraction and allows a programmer to concentrate on the business logic of the application. Following is an example of a query in Pony: select(p for p in Product if p.name.startswith('A') and p.cost <= 1000) Pony translates queries to SQL using a specific database dialect. ...
    Downloads: 0 This Week
    Last Update:
    See Project
  • 19
    The Flamenco search and browse interface framework uses hierarchical faceted metadata to allow users to both refine and expand queries, while maintaining a consistent representation of a collection and seamlessly integrating keyword queries.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 20
    A cgi program written in Python that turns HTTP GET and POST queries into SQL queries, runs them, turns the results into XML, and then returns the XML as the response to the HTTP query. It also supports returning a single BLOB as the whole response.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 21
    Libdejector is a database tool which defeats SQL injection attacks by performing context-free validation of queries. While written in C, SWIG wrappers exist for Python and other languages will be following soon.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 22
    PyORQ (Python Object Relational binding with Queries) defines a new object-relational mapping. Native Python expressions which are translated automatically into SQL allow you to use the search capability of a relational database in an OO environment.
    Downloads: 0 This Week
    Last Update:
    See Project
  • Previous
  • You're on page 1
  • Next