Search Results for "sql table"
Sort By:
Showing 409 open source projects for "sql table"
View related business solutions-
Our Free Plans just got better! | Auth0You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
-
Gemini 3 and 200+ AI Models on One PlatformBuild generative AI apps with Vertex AI. Switch between models without switching platforms.
-
1
Kysely SQL
A type-safe TypeScript SQL query builder
Kysely is a type-safe TypeScript SQL query builder that provides an intuitive and autocompletion-friendly API. It allows developers to construct complex SQL queries with full type safety, reducing runtime errors and improving code maintainability. Kysely supports various SQL dialects and is compatible with Node.js, Deno, and browser environments. -
2
MySQL Edit Table
Editor for MySQL - PHP class
Editor for MySQL database tables. Edit, View or Add records of a MySQL table. Languages: English, French, German, Italian, (Mex) Spanish, Dutch and Swedish -
3
SQLiteStudio
A free, open source, multi-platform SQLite database manager
A free, open-source, multi-platform SQLite database manager written in C++, with use of Qt framework. It's free of charge for everybody, for any purpose (including commercial). It's safe, as anyone can review the source code. The SQL Editor window assists users with SQL syntax hints & highlighting, provides pretty-print code formatter, and marks syntax errors. You can Ctrl+click on the table mentioned in the SQL query to open that table (or index, or trigger, or view). Currently supported encrypted, password-protected SQLite variations are SQLCipher, WxSQLite3, and System.Data.SQLite. ... -
4
DbGate
Database manager for MySQL, PostgreSQL, SQL Server, MongoDB
...Runs as an application for Windows, Linux and Mac. Or in Docker container on the server and in a web browser on the client. Import, export from/to CSV, Excel, JSON, XML. Free table editor - quick table data editing (cleanup data after import/before export, prototype tables, etc.) Archives - back up your data in JSON files on local filesystem (or on DbGate server, when using web application) Charts, export chart to HTML page. -
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.
-
5
Adminer
Database management in a single PHP file
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, MongoDB and others via plugin. Replace phpMyAdmin with Adminer and you will get a tidier user interface, better support for MySQL features, higher performance and more security. Connect to a database server with username and password. Select an existing database or create a new one. List fields, indexes, foreign keys and triggers of table Change name, engine, collation, auto_increment and comment of table. ... -
6
tableExport.jquery.plugin
jQuery plugin to export a html table to JSON, XML, CSV, TSV, TXT, SQL
jQuery plugin to export an html table to JSON, XML, CSV, TSV, TXT, SQL, Word, Excel, PNG, and PDF. -
7
Antares
A modern, fast and productivity driven SQL client with a focus in UX
Antares is a modern, cross-platform SQL client built with Electron and Vue.js. It offers a clean and intuitive UI for managing databases like MySQL, PostgreSQL, SQLite, and more. Designed for developers and DBAs, Antares supports tabbed browsing, query editing with syntax highlighting, and visual schema exploration, making it a powerful alternative to heavier database tools. -
8
Beekeeper Studio
Cross-platform SQL Editor and Database Manager
Beekeeper Studio is an open source, cross-platform SQL editor and database management app that is both powerful and easy to use. It lets you query and manage your relational databases, with support for connecting to SQLite, MySQL, MariaDB, Postgres, SQL Server and Amazon Redshift databases. Unlike most other open source SQL editors and database managers, Beekeeper Studio isn’t cluttered with unnecessary features, but does come with the essentials that you need. This includes SQL auto... -
9
pg_graphql
GraphQL support for PostgreSQL
pg_graphql is a PostgreSQL extension that enables querying the database with GraphQL using a single a SQL function. The extension reflects a GraphQL schema from the existing SQL schema and exposes it through a SQL function, graphql. resolve(...). This enables any programming language that can connect to PostgreSQL to query the database via GraphQL with no additional servers, processes, or libraries. Each table receives an entry point in the top-level Query type that is a pageable collection with relationships defined by its foreign keys. ... -
Powerful App Monitoring Without Surprise BillsTired of monitoring tools that punish you for scaling? AppSignal offers transparent, predictable pricing with every feature unlocked on every plan. Track errors, monitor performance, detect anomalies, and manage logs across Ruby, Python, Node.js, and more. Trusted by developers since 2012 with free dev-to-dev support. No credit card required to start your 30-day trial.
-
10
DQO Data Quality Operations Center
Data Quality Operations Center
DQO is an DataOps friendly data quality monitoring tool with customizable data quality checks and data quality dashboards. DQO comes with around 100 predefined data quality checks which helps you monitor the quality of your data. Table and column-level checks which allows writing your own SQL queries. Daily and monthly date partition testing. Data segmentation by up to 9 different data streams. Build-in scheduling. Calculation of data quality KPIs which can be displayed on multiple built-in data quality dashboards. -
11
DB Browser for SQLite
The DB Browser for SQLite
DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. DB4S is for users and developers who want to create, search, and edit databases. DB4S uses a familiar spreadsheet-like interface, and complicated SQL commands do not have to be learned. This program is not a visual shell for the sqlite command line tool, and does not require familiarity with SQL commands. It is a tool to be used by both developers and end users, and must remain as simple to use as possible in order to achieve these goals. Import and export records as text, import and export tables from/to CSV files, import and export databases from/to SQL dump files, issue SQL queries and inspect the results, examine a log of all SQL commands issued by the application, plot simple graphs based on table or query data. -
12
Sequelize
A promise-based multi SQL dialect Node.js ORM
Sequelize is a promise-based Node.js ORM for Postgres, MySQL, MariaDB, SQLite and Microsoft SQL Server. It features solid transaction support, relations, eager and lazy loading, read replication and more. Sequelize follows SEMVER. Supports Node v6 and above to use ES6 features. Sequelize v5 was released on March 13, 2019. Official TypeScript typings are now included. Sequelize can be used since the beginning in order to automate the creation of every table in your database. ... -
13
PGManage
Web tool for database management
pgManage is an open-source, cross-platform desktop GUI for managing PostgreSQL databases. It provides a tabbed interface for browsing schemas, writing queries, and managing server configurations. Designed for both developers and DBAs, pgManage aims to be a user-friendly yet powerful alternative to pgAdmin. -
14
CDC Connectors for Apache Flink
CDC Connectors for Apache Flink
...CDC connectors for DataStream API, users can consume changes on multiple databases and tables in a single job without Debezium and Kafka deployed. CDC connectors for Table/SQL API, users can use SQL DDL to create a CDC source to monitor changes on a single table. CDC Connectors for Apache Flink® supports ingesting snapshot data and real time changes from databases to Flink®. -
15
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. ... -
16
Genji
Document-oriented, embedded SQL database
...Genji was designed for simplicity in mind. It is really easy to insert and read documents of any shape. Genji mixes the best of both worlds by combining powerful SQL commands with JSON. Genji tables are schemaless, but it is possible to add constraints on any field to ensure the coherence of data within a table. -
17
Apache Iceberg
Apache Iceberg
Iceberg is a high-performance format for huge analytic tables. Iceberg brings the reliability and simplicity of SQL tables to big data while making it possible for engines like Spark, Trino, Flink, Presto, Hive, and Impala to safely work with the same tables, at the same time. The core Java library that tracks table snapshots and metadata is complete, but still evolving. Current work is focused on adding row-level deletes and upserts, and integration work with new engines like Flink and Hive. ... -
18
pgstream
PostgreSQL replication with DDL changes
pgstream is an open source CDC command-line tool and library that offers Postgres replication support with DDL changes to any provided output. One of the main differentiators of pgstream is the fact that it tracks and replicates schema changes automatically. It relies on SQL triggers that will populate a Postgres table (pgstream.schema_log) containing a history log of all DDL changes for a given schema. Whenever a schema change occurs, this trigger creates a new row in the schema log table with the schema encoded as a JSON value. This table tracks all the schema changes, forming a linearised change log that is then parsed and used within the pgstream pipeline to identify modifications and push the relevant changes downstream. -
19
Backup Tables
Backup single or multiple database tables with ease
Backup single or multiple database tables with ease. Use the BackupTables::generateBackup($tableToBackup) Facade anywhere in your application and it will generate $tableToBackup_backup_2024_08_22_17_40_01 table in the database with all the data and structure. Note that the datetime 2024_08_22_17_40_01 will be varied based on your datetime. -
20
sq data wrangler
sq data wrangler
sq is a command line tool that provides jq-style access to structured data sources: SQL databases, or document formats like CSV or Excel. sq executes jq-like queries, or database-native SQL. It can join across sources: join a CSV file to a Postgres table, or MySQL with Excel. sq outputs to a multitude of formats including JSON, Excel, CSV, HTML, Markdown and XML, and can insert query results directly to a SQL database. sq can also inspect sources to view metadata about the source structure (tables, columns, size). ... -
21
DbInspector
Android library for viewing, editing and sharing in app databases.
...Preview all application sandbox databases. Import single or multiple databases at once. Search, delete, rename, copy, share a database. Preview tables, views, and triggers. Preview table or view pragma. Preview table or view pragma. Search table, view or trigger. Sort table, view or trigger per column. Execute any valid SQL command in editor per database connection. If you use DbInspector for a specific flavor and need to override merged in launcher label, you can provide a String resource in your project. DbInspector has a build in editor scoped per database connection currently used. -
22
Kotlin Dataframe
Structured data processing in Kotlin
Data frame is an abstraction for working with structured data. Essentially it’s a 2-dimensional table with labeled columns of potentially different types. You can think of it like a spreadsheet or SQL table, or a dictionary of series objects. The handiness of this abstraction is not in the table itself but in a set of operations defined on it. The Kotlin Dataframe library is an idiomatic Kotlin DSL defining such operations. The process of working with data frame is often called data wrangling which is the process of transforming and mapping data from one "raw" data form into another format that is more appropriate for analytics and visualization. ... -
23
goose
A database migration tool. Supports SQL migrations and Go functions
goose is a database migration tool. Manage your database schema by creating incremental SQL changes or Go functions. Starting with v3.0.0 this project adds Go module support, but maintains backwards compatibility with older v2.x.y tags. Goose supports embedding SQL migrations, which means you'll need go1.16 and up. If using go1.15 or lower, then pin v3.0.1. We use timestamped migrations by default but recommend a hybrid approach of using timestamps in the development process and sequential versions in production. ... -
24
Sequin
Postgres change data capture to streams and queues like Kafka
Sequin is a change data capture (CDC) system that replicates API data to Postgres in real time. It syncs services like Stripe, Salesforce, and GitHub into PostgreSQL tables, enabling developers to query third-party data with standard SQL. Sequin is ideal for building data-driven applications that need immediate visibility into external SaaS platforms. -
25
Kysely
A type-safe typescript SQL query builder
Kysely (pronounce “Key-Seh-Lee”) is a type-safe and autocompletion-friendly typescript SQL query builder. Inspired by knex. Mainly developed for node.js but also runs on deno and in the browser. Kysely makes sure you only refer to tables and columns that are visible to the part of the query you're writing. The result type only has the selected columns with correct types and aliases. As an added bonus you get autocompletion for all that stuff. As shown in the gif above, through the pure magic...
