You can connect to SQL and NoSQL. What type of database you choose is really up to you. There are pros and cons for each, it really depends on your use cases. The APIs in DreamFactory really work the same, regardless of whether you’re using a SQL or NoSQL database on the backend.
In terms of schema management, DreamFactory currently allows you to manage SQL schema (both the MySQL db that comes with DreamFactory or any remote SQL db that you connect to). We’ll support NoSQL collection visibility / management in the future.