Search Results for "scripts"

ChartDB is a web-based database diagramming editor that allows users to visualize and design their database schemas with a single "Smart Query." It offers instant schema import, customization options, and the ability to export SQL scripts, all without requiring an account. ChartDB is ideal for developers and teams looking to streamline database design and documentation.

...If installed globally (with the -g option), you can run node-pg-migrate and if not, you can run ./node_modules/.bin/node-pg-migrate. Add "migrate": "node-pg-migrate" to scripts section of package.json so you are able to quickly run commands. Run npm run migrate create my first migration. It will create file xxx_my-first-migration.js in migrations folder. Now you should put your DB connection string to DATABASE_URL environment variable and run npm run migrate up. (e.g. DATABASE_URL=postgres://test:test@localhost:5432/test npm run migrate up).

StackRender is a visual database schema editor that helps developers design, evolve, and deploy databases faster. Instead of manually writing migration scripts or managing schema changes through ORMs, StackRender lets you modify your database visually using ER diagrams and automatically generates the required SQL migrations. This makes schema evolution safer, faster, and easier to review. Supporting PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, and Oracle, StackRender streamlines the entire database development workflow—from initial schema design to ongoing migrations as your application grows. ...

...It allows you to easily build graphs and tables with data pulled from SQL databases, logging databases, metrics databases, HTTP servers, and all kinds of text and binary files. Need to join or munge data? Write embedded scripts as needed in languages like Python, JavaScript, R or SQL. All in one application. Build reports with graphs, charts and tables. Script against data. Cross-platform: Windows, macOS, and Linux. Easily fetch your data, wherever it is: 18 SQL and non-SQL databases, files, HTTP server. Over 20 supported databases out of the box including: PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, Oracle, ClickHouse, Influx 1 (InfluxQL), Influx 2 (Flux), Prometheus, Elasticsearch, AWS Athena, Google BigQuery, Snowflake, Cassandra, Scylla, TimescaleDB, YugabyteDB, CockroachDB, CrateDB, QuestDB, and Airtable.