Search Results for "sql table"
Sort By:
Showing 26 open source projects for "sql table"
View related business solutions-
MongoDB Atlas runs apps anywhereMongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
-
Try Google Cloud Risk-Free With $300 in CreditUse your credit across every product. Compute, storage, AI, analytics. When it runs out, 20+ products stay free. You only pay when you choose to.
-
1
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. ... -
2
peewee
A small, expressive orm, which supports postgresql, mysql and sqlite
Peewee is a simple and small ORM. It has few (but expressive) concepts, making it easy to learn and intuitive to use. Peewee will automatically infer the database table name from the name of the class. You can override the default name by specifying a table_name attribute in the inner “Meta” class (alongside the database attribute). To learn more about how Peewee generates table names, refer to the Table Names section. There are lots of field types suitable for storing various types of data. Peewee handles converting between pythonic values and those used by the database, so you can use Python types in your code without having to worry. ... -
3
Bracket
Selfhosted tournament system
Bracket is an open-source tool that tracks and manages data access across your PostgreSQL database. It provides visibility into which parts of your codebase are accessing which tables and columns, enabling data governance, security auditing, and architectural insights. Bracket is particularly helpful for growing teams needing better observability in complex applications. -
4
peepDB
CLI tool and python library to inspect databases fast
peepDB is an open-source command-line tool and Python library designed for developers and database administrators who need a fast and efficient way to inspect their database tables without writing SQL queries. With support for MySQL, PostgreSQL, and MariaDB, peepDB is lightweight, secure, and incredibly easy to use. -
Gemini 3 and 200+ AI Models on One PlatformBuild generative AI apps with Vertex AI. Switch between models without switching platforms.
-
5
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. -
6
EdgeDB
A next-generation graph-relational database
...We call it a graph-relational database. The core unit of schema in the graph-relational model is the object type, analogous to a table in SQL. Object types contain properties and can be linked to other object types to form a schema graph. -
7
sqlite-utils
Python CLI utility and library for manipulating SQLite databases
...As a library, it exposes high-level APIs for inserting records, creating or transforming tables, normalizing schemas, and running migrations that SQLite’s limited ALTER TABLE cannot handle directly. The project also embraces an ecosystem of plugins, so you can add custom SQL functions, extra commands, or UIs (including a terminal UI) via separate packages. Because it’s designed by someone who uses SQLite heavily in real projects, the tool includes many small quality-of-life features. -
8
MySQL 2 Excel Exporter 3-105 [I.S.A]
MySQL 2 Excel: Exporter 3-105 [Improved.Simplified.Alternative]
'MySQL2Excel_Exporter' is an desktop application developed using python 3.6.8 and other add-on libaries. The application exports MySql tables as a excel file. MySQL2Excel_Exporter has two parts: 1) Export - converts all records in mySQL table into excel file 2) Export Filter - converts selected recorerds in mySQL table into excel file Compatible only for windows OS. -
9
Swiple
Swiple enables you to easily observe, understand, validate data
Swiple is an automated data monitoring platform that helps analytics and data engineering teams seamlessly monitor the quality of their data. With automated data analysis and profiling, scheduling and alerting, teams can resolve data quality issues before they impact mission critical resources. Experience hassle-free integration with Swiple's zero-infrastructure and zero-code setup. Seamlessly incorporate data quality checks into your existing workflows without any coding or infrastructure... -
AI-generated apps that pass security reviewRetool lets you generate dashboards, admin panels, and workflows directly on your data. Type something like “Build me a revenue dashboard on my Stripe data” and get a working app with security, permissions, and compliance built in from day one. Whether on our cloud or self-hosted, create the internal software your team needs without compromising enterprise standards or control.
-
10
q - Text as Data
Run SQL directly on CSV or TSV files
q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files). q treats ordinary files as database tables, and supports all SQL constructs, such as WHERE, GROUP BY, JOINs etc. It supports automatic column name and column type detection, and provides full support for multiple encodings. q fully supports all types of encoding. Use -e data-encoding to set the input data encoding, -Q query-encoding to set the query encoding, and use -E... -
11
FAKE2DB
Create custom test databases that are populated with fake data
Generate fake but valid data filled databases for test purposes using most popular patterns(AFAIK). Current support is sqlite, mysql, postgresql, mongodb, redis, CouchDB. The installation through pypi retrieves 'fake-factory' as a main dependency. db argument takes 6 possible options, sqlite, mysql, postgresql, mongodb, redis, CouchDB. name argument is OPTIONAL. When it is absent fake2db will name db's randomly. host argument is OPTIONAL. Hostname to use for database connection. Not used for... -
12
pyNessusParser
Export a Nessus Report in a MySql DB
This python script with GUI allows to export a .nessus file into a common MySql database. It is possible to select in the GUI what field it will parsed and, therefore, the columns of the mysql table. -
13
PyLucid is a Open Source web content management system written in Python using the Django Framework. fully customizable output, expandable with plugins, i18n, L10n, Revision controled, support many database engines, WSGI conform and many more...
-
14
Data Migrator for Oracle
Migrate/Copy your data between Oracle database and 13 major DBs.
Command line data Copy/Migration tool for Oracle. Supports Oracle 7.3, Oracle 8i, Oracle 9i, Oracle 10G, Oracle 11G and 13 major databases. 1. Exadata 2. Sybase ASE 3. Informix Innovator C 4. Sybase SQL Anywhere 5. DB2 UDB 6. CSV 7. SQLServer 8. MariaDB 9. Sybase IQ 10. PostgreSQL 11. MySQL 12. Informix IDS 13. TimesTen -
15
DataMule
Extract-Copy-Load (ECL) tool for 14 databases.
Extract, Copy and Load operations for: 1. Sybase ASE 2. Informix Innovator C 3. Sybase SQL Anywhere 4. DB2 UDB 5. SQLServer 6. MariaDB 7. Sybase IQ 8. PostgreSQL 9. MySQL 10. Informix IDS 11. TimesTen 12. Oracle 13. SQL Lite 14. Exadata Total 224 data copy vectors. CSV -> DB. DB->DB DB->CSV -
16
CSV*Extractor Pro (Windows command line)
Spool you scalar data in CSV format from 14 major Databases.
Command line tool for data export from major relational data stores (RDBMS). DB2 Advanced Enterprise Server DB2 Advanced Workgroup Server DB2 Developer Edition DB2 Enterprise Server DB2 Express DB2 Express C DB2 Workgroup Server Exadata Infobright Informix IDS Informix Innovator C MariaDB MySQL Oracle Oracle XE PostgreSQL SAP Sybase ASE SQL Lite SQL Server Enterprise SQL Server Express Sybase IQ Sybase SQL Anywhere TimesTen -
17
Python scripts that help you pull out hardcoded strings from your source codes and represent them as a .csv table. You can then write localized versions of those strings and put them back into your code. Currently supports: .php, .js, .html, .sql
-
18
SQLServer ->SQLServer Data Migrator
Copy data between your SQLServer instances
Ad-hoc data replication for SQLServer 2005,2008,2010 and 2012. Touch-and-go design requires you to provide just login info, query file with your SQL and target table name. -
19
Data Spooler for SQLServer #SaveUkraine
Extracts table or query data from SQL Server 2005, 2008, 2012
#SaveUkraine #StopRussia #FreeUkraine #StopPutin #CrimeaIsUkraine #UnitedForUkraine #RussiaInvadedUkraine Spools/extracts/dump table or query data from SQL Server 2015, 2008,2012. Serial spool creates single dump file. Turbo mode offers 5x spool performance improvement. Sharded turbo more creates multiple files. -
20
DataCopy For SQLServer
Data Copy tool for SQL Server and Oracle
Migrate your data from SQLServer to Oracle without creating single dump file. Input is a SQLServer query file defining dataset you want to copy to Oracle. Target table has to exist for copy to go through. Turbo mode offers 5x copy performance improvement. -
21
pyMantis is a data-management system for (systems) biology build on the web2py framework. It features: tree based file explorer, relational db table wizzard with automated creation of user interfaces, internal and external access management, wiki, ..
-
22
ExploitMyUnion is a tool written in Python with a PyQt user interface made to automate sql injection exploitation.
-
23
Python library provides the briefest way to construct SQL queries in JSON form. Simple example: ('*','table',id:[1,3]) is Select * from table where id in [1,3]. Sqlalchemy patch module is provided to extend sqlalchemy with convenient jsonSQL meth
-
24
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).
-
25
mssql2mysql is a python script used to create a SQL dump from a Microsoft SQL server that is ready to use with MySQL. Supports Schema and data dumping, including Primary Keys for each table, allows to dump all data or just a small portion of it
