NocoDB - The Open Source Airtable alternative

We have collection of more than 1 Million open source products ranging from Enterprise product to small libraries in all platforms. We aggregate information from all open source repositories. Search and find the best for your needs. Check out projects section.

NocoDB - The Open Source Airtable alternative

NocoDB is an open source Airtable alternative. NocoDB works by connecting to any relational database and transforming them into a smart spreadsheet interface! This allows you to build no-code applications collaboratively with teams. NocoDB currently works with MySQL, PostgreSQL, Microsoft SQL Server, SQLite, Amazon Aurora & MariaDB databases.

Also NocoDB's app store allows you to build business workflows on views with combination of Slack, Microsoft Teams, Discord, Twilio, Whatsapp, Email & any 3rd party APIs too. Plus NocoDB provides programmatic access to APIs so that you can build integrations with Zapier / Integromat and custom applications too.

https://docs.nocodb.com
https://github.com/nocodb/nocodb

Tags	mysql graphql rest-api sqlite postgresql swagger spreadsheet mariadb airtable sqlserver restful-api low-code no-code automatic-api no-code-database airtable-alternative workflow kanban-board
Implementation	Vue
License	AGPLv3
Platform	NodeJS

Related Projects

sandman2 - Automatically generate a RESTful API service for your legacy database. No code required!

Python

sandman2 automagically generates a RESTful API service from your existing database, without requiring you to write a line of code. Simply point sandman2 to your database, add salt for seasoning, and voila!, a fully RESTful API service with hypermedia support starts running, ready to accept HTTP requests. This is a big deal. It means every single database you interact with, from the SQLite database that houses your web browser's data up to your production PostgreSQL server can be endowed with a REST API and accessed programatically, using any number of HTTP client libraries available in every language. sandman2 frees your data.

sqlalchemy database rest-api restful-api rest orm sqlite-database automatic-api

php-crud-api - Single file PHP script that adds a REST API to a SQL database

Single file PHP 7 script that adds a REST API to a MySQL 5.6 InnoDB database. PostgreSQL 9.1 and MS SQL Server 2012 are fully supported. NB: This is the TreeQL reference implementation in PHP.

api-server restful mysql geospatial postgresql php-api postgis crud rest-api openapi swagger automatic-api database multi-database sql-database ubuntu-linux geojson sqlserver

Prisma - Next-generation ORM for Node.js and TypeScript

Typescript

Prisma helps app developers build faster and make fewer errors with an open source ORM for PostgreSQL, MySQL and SQLite. It makes database access easy with an auto-generated and type-safe query builder that's tailored to your database schema. It provides an alternative to traditional ORMs and SQL query builders.

mysql postgres mongo sql-server orm database mongodb sqlite postgresql mariadb mssql sqlserver mongodb-orm prisma-client nodejs-orm rest-api database-migration

Tooljet - Internal tool builder. An alternative to Retool, AppSmith, JetAdmin, Internal.io etc

Ruby

ToolJet is an open-source no-code framework to build and deploy internal tools quickly without much effort from the engineering teams. You can connect to your data sources such as databases ( like PostgreSQL, MongoDB, Elasticsearch, etc ), API endpoints ( ToolJet supports importing OpenAPI spec & OAuth2 authorization) and external services ( like Stripe, Slack, Google Sheets, Airtable ) and use our pre-built UI widgets to build internal tools.

internal-tools reactjs self-hosted ruby-on-rails no-code rails6 retool appsmith jetadmin no-code-framework

Baserow - Online database tool and Airtable alternative

Python

Baserow is an open source online database tool and Airtable alternative. Create your own database without technical experience. It has user friendly no-code tool gives you the powers of a developer without leaving your browser.

database-tools online-database airtable-alternative

PostgREST - RESTful API from any existing PostgreSQL database

Haskell

PostgREST serves a fully RESTful API from any existing PostgreSQL database. The structural constraints and permissions in the database determine the API endpoints and operations. It is an alternative to manual CRUD programming. Custom API servers suffer problems. Writing business logic often duplicates, ignores or hobbles database structure. Object-relational mapping is a leaky abstraction leading to slow imperative code. The PostgREST philosophy establishes a single declarative source of truth: the data itself.

rest-api api-server postgresql postgrest automatic-api

Rowy - Open-source Airtable-like experience for your database (Firestore) with GCP's scalability

Typescript

Manage Firestore data in a spreadsheet-like UI, write Cloud Functions effortlessly in the browser, and connect to your favorite third party platforms such as SendGrid, Twilio, Algolia, Slack and more. It supports CRUD operations, Sort and filter by row values, Lock, Freeze, Resize, Hide and Rename columns, Multiple views for the same collection, Bulk import or export data - csv, json.

react firebase algolia typescript database serverless excel gcp spreadsheet google-cloud admin-dashboard google-cloud-platform hacktoberfest low-code cloud-functions gcp-cloud-functions admin-portal firestore gcp-firestore airtable-alternative

Coolify - An open-source, hassle-free, self-hostable Heroku & Netlify alternative

Typescript

Coolify is an open-source, hassle-free, self-hostable Heroku & Netlify alternative. You can deploy Static Sites, any Node.js based applications, PHP, Rust applications hassle-free with automatic reverse proxy and SSL certs. You can create your own instance of MongoDB, MySQL, PostgreSQL, CouchDB, RedisDB, WordPress, Plausible Analytics, NocoDB, MinIO or VSCode Server.

heroku-alternative netlify-alternative cloud-platform paas platform-as-a-service mysql couchdb docker redis php vuejs mongodb analytics reactjs nextjs postgresql static svelte databases minio mysql-database self-hosted vscode-server

graphjin - GraphJin - Build APIs in 5 minutes with GraphQL. An instant GraphQL to SQL compiler.

GraphJin gives you a high performance GraphQL API without you having to write any code. GraphQL is automagically compiled into an efficient SQL query. Use it either as a library or a standalone service. After working on several products through my career I found that we spend way too much time on building API backends. Most APIs also need constant updating, and this costs time and money.

mysql rails graphql docker sql database graph postgresql graphql-server cloud-native ruby-on-rails automatic-api yugabyte database-query postgres

automatic-api - A list of software that turns your database into a REST/GraphQL API

The following is a list of tools that automatically expose a REST, GraphQL, or another kind of API for your database, as well as databases with a built-in HTTP API. GitHub stats updated 2018-07-17. The commit count and the latest commit date are for the default branch (usually master).

list rest-api restful-api graphql graphql-api rest automatic-api

xmysql - :rocket: One command to generate REST APIs for any MySql Database.

Javascript

Generating REST APIs for a MySql database which does not follow conventions of frameworks such as rails, django, laravel etc is a small adventure that one like to avoid .. Hence this.

rest-api restful-api nodejs automatic-api xmysql mysql-database api-server mysql-restful mysql-rest-api-generator node-mysql-rest-api rest restful rest-apis

safrs - SqlAlchemy Flask-Restful Swagger Json:API OpenAPI

Python

SAFRS is an acronym for SqlAlchemy Flask-Restful Swagger. The purpose of this framework is to help python developers create a self-documenting JSON API for sqlalchemy database objects and relationships. These objects can be serialized to JSON and can be created, retrieved, updated and deleted through the JSON API. Optionally, custom resource object methods can be exposed and invoked using JSON. Class and method descriptions and examples can be provided in yaml syntax in the code comments. The description is parsed and shown in the swagger web interface. The result is an easy-to-use swagger/OpenAPI and JSON:API compliant API implementation.

flask json sqlalchemy json-api rest-api swagger openapi python3 flask-sqlalchemy flask-restful openapi3

Keploy - No code API testing platform. Create unit tests and data mocks from API calls

Keploy is a no-code testing platform that generates tests from API calls. It converts API calls into testcases. Mocks are automatically generated with the actual request/responses.

testing api productivity unit-testing test-automation testing-tools test-driven-development api-testing go-testing test-automation-framework unit-testing-framework nocode record-replay record-replay-test no-code low-code

connexion - Swagger/OpenAPI First framework for Python on top of Flask with automatic endpoint validation & OAuth2 support

Python

Connexion is a framework on top of Flask that automagically handles HTTP requests based on OpenAPI 2.0 Specification (formerly known as Swagger Spec) of your API described in YAML format. Connexion allows you to write a Swagger specification, then maps the endpoints to your Python functions; this makes it unique, as many tools generate the specification based on your Python code. You can describe your REST API in as much detail as you want; then Connexion guarantees that it will work as you specified.With Connexion, you write the spec first. Connexion then calls your Python code, handling the mapping from the specification to the code. This incentivizes you to write the specification so that all of your developers can understand what your API does, even before you write a single line of code.

openapi api-rest swagger flask-extensions

n8n - Workflow Automation Tool

Typescript

n8n (pronounced n-eight-n) is an extendable workflow automation tool. It helps you to interconnect every app with an API in the world with each other to share and manipulate its data without a single line of code. It is an easy to use, user-friendly and highly customizable service, which uses an intuitive user interface for you to design your unique workflows very fast. Hosted on your server and not based in the cloud, it keeps your sensible data very secure in your own trusted database.

cli workflow integrations development automation node iaas data-flow self-hosted ipaas apis automated workflow-automation low-code integration-framework low-code-development-platform low-code-plattform no-code

DbGate- Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others

Svelte

DbGate is cross-platform database manager. It's designed to be simple to use and effective, when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualisation or batch export and import. It supports MySQL, PostgreSQL ,SQL Server, MongoDB, Redis, SQLite, Amazon Redshift, CockroachDB, and MariaDB.

electron mysql sql sql-server mongodb sqlite postgresql database-gui database-manager database-tools

just-api - Easy and Flexible API Testing

Javascript

Just-API is a declarative, specification based test framework for REST, GraphQL APIs. Users can test APIs without writing code, but they can also tap into code when they want to. It reads API test specification from YAML files and runs them in serial/parallel mode. Test reports can be generated in several formats including HTML and JSON. To run just-api, you will need Node.js v7.10.0 or newer.

api automation webservice-test graphql-testing http-api-testing testing yaml graphql tests test-framework microservice-testing http rest webservice api-testing mocha test restful microservice testrunner qa testreporter

Bebop - Simple discussion board / forum web application.

Bebop is a simple discussion board / forum web application.Create a new empty database (MySQL оr PostgreSQL) that will be used as a data store and a database user with all privileges granted on this database.

forum discussion-board web-app rest-api vuejs

Swagger - The World's Most Popular API Framework

Java

Swagger is a powerful open source framework backed by a large ecosystem of tools that helps you design, build, document, and consume your RESTful APIs. The goal of Swagger is to define a standard, language-agnostic interface to REST APIs which allows both humans and computers to discover and understand the capabilities of the service without access to source code, documentation, or through network traffic inspection.

rest-api api-framework api-specification api-testing rest-framework api-documentation apidoc

PostGraphile - High-performance GraphQL API for your PostgreSQL database

Typescript

PostGraphile is an instant, highly-performant GraphQL API for your PostgreSQL database, extensible via a powerful plugin system. It allows you to access the power of PostgreSQL through a well designed, extensible, customisable and incredibly performant GraphQL server. It automatically detects tables, columns, indexes, relationships, views, types, functions, comments, and more - providing a GraphQL server that is highly intelligent about your data, and that automatically updates itself without restarting when you change your database schema.