Can Datafliq write to my database?
No. Every connection Datafliq opens is read-only: your data can be read, never changed or deleted. An assistant cannot alter a row, drop a table, or touch your schema, and two separate controls enforce that.
Your database enforces it. On Postgres, MySQL and SQLite, Datafliq opens the connection in read-only mode, so your own database refuses any write outright. The guarantee comes from the engine that holds your data rather than from software sitting in front of it, and on Postgres it protects your schema as well as your rows.
Datafliq enforces it too. Before anything runs, every source gets a second check: only a single, straightforward read statement is allowed through. That check works from a list of what is permitted rather than a list of what is banned, so reads reach your data and nothing else does. It covers every source you can connect, including spreadsheets and SQL Server. MongoDB connections only ever issue a find.