NocoDB is an open source Airtable alternative.
This works by connecting to any relational database and transforming them into a smart spreadsheet interface and allows you to build no-code applications collaboratively with teams. Currently, it works with MySQL, PostgreSQL, Microsoft SQL Server, SQLite, Amazon Aurora & MariaDB databases.
Salient Features of nocodb:
- Its easy to search, sort and filter just like spreadsheets,
- Create custom and shared views,
- Role based access,
- Provide workflow automation by connect with chat, email and SMS services,
- API access through swagger etc.
While above are feature available in open source version, Enterprise version provide
- SSO, SLA, Organisation wide reports and analytics,
- Advanced Audit or ACL,
- A hosted solution.
How to connect with nocodb:
Assuming the SSO is already configured, Lets see how to connect. If not, please use this URL for steps.
install sshuttle by running below:
brew install sshuttle
copy to ~/.ssh/config
host i-*.* mi-*.*
ProxyCommand bash -c "aws ssm start-session --target $(echo %h|cut -d'.' -f1) --profile $(echo %h|/usr/bin/cut -d'.' -f2) --document-name AWS-StartSSHSession --parameters 'portNumber=%p'"
run below commands:
aws sso login --profile <profile-name>
aws ec2-instance-connect send-ssh-public-key --instance-id <instance_id> --instance-os-user wegodev --ssh-public-key file:///Users/<username>/.ssh/id_rsa.pub --availability-zone <availability zone> --region <region> --profile <profile_name>
sshuttle -r wegodev@<ssm-instance-id>.<profile_name> <cidr-range>
Load the url according to environment and use google auth,
Login to application using google oauth, where you can see projects in nocodb. Green radio button to the side indicates project you have permission to access.
considering the viewer role has limited permission, few basic operations can be carried out like filter, sort and search.
Amazing productivity tool with lot more features to do some database level changes with right access, detailed documentation and demos are available here.