Free sql developer software for mac

MySQL Database Server 5.1.35 is a versatile and innovative tool which is designed for enterprise organizations delivering business critical database applications. It gives corporate developers, DBAs and ISVs an array of new enterprise features to make more productive developing, deploying, and managing industrial strength applications. If you need a GUI for MySQL Database, you can download - NAVICAT (MySQL GUI). It supports to import Oracle, MS SQL, MS Access, Excel, CSV, XML or other formats to MySQL.

MySQL Database Server delivers new enterprise features, including: ACID Transactions to build reliable and secure business critical applications. Stored procedures to improve developer productivity. Triggers to enforce complex business rules at the database level. Views to ensure sensitive information is not compromised. Information schema to provide easy access to metadata. Distributed transactions (XA) to support complex transactions across multiple databases.

Cache Monitor supports developers with features, like: Advanced SQL Query Editor, Cache-SQL Syntax highlighting, SQL Code completion, SQL History buffer for executed SQL commands, SQL Code formatting,Graphical SQL execution plan and more.
You see the process ID (PID) from your connection on the Tabpane on every Query Analyzer. Code completion will let you type a few characters and then display a list of context-sensitive possibilities to complete the text you are typing. Editor code completion brings up a list of Tables or Columns (also known as Intellisense).
Code completion can be triggered by pressing [CTRL+SPACE] or by typing a hotchar or keyword, such as . or , in an SELECT list. Cache-SQL formatting can executed from context menu to make your code, or the code of others, much easier to read (Format SQL). Also supports, of course: Undo/Redo and Search and Replace.
Since version 0.18 the Hyperlink navigation has been added. Hyperlink navigation is a means for simple navigation from the editor to Tables metadata. When you presses the CTRL key and hover the mouse cursor over a certain code element, the element is changed to a hyperlink. When you hold the CTRL key and click on the hyperlink, the go to Tables metadata action is performed.
Since 0.20, Cache Monitor contains features to tune the database.
Main features:
Advanced SQL Query Editor
- Cache-SQL Syntax highlighting
- SQL Code completion for Tables,Views,Columns and Indexes (also known as Intellisense)
- SQL History buffer for executed SQL commands
- SQL Code formatting
- Parallel (multi-threaded) queries
- The Graphical SQL execution plan supplies index and selectivity information from every used index in the plan
- SQL abbreviations, Type: se to complete to "SELECT * FROM "
- TuneTable for selected Tables or whole Namespaces
- Select2Table Function
DDL Code generation (CREATE TABLE)
MetaData-Browser for
- Namespaces
- Tables
- Views
- Routines
- Classes
- CachedQueries
- Stored Procedures
- Indexes
Cache Monitor can be used from any platform with an JAVA-JRE 5.0 (Linux, Windows,...).
- Cache Monitor helps you to organize your Server; to classify Cache Servers into groups, divide groups into subgroups etc.
- You can see Cache Version infos from connected Server
- Shows Executionplan from an SQL Statement.
- You can view the selectivity from the used columns in the execution plan
- Shows CachedQueries with their costs and the underlying SQL (AddHoc from Intersystems needed!)
- Select2Table Function
- Fast open Query Analyzer with CTRL+Q on selected Server
- Fast open Query Analyzer with CTRL+O
- CopyTable Function
- Execute TuneTable for selected Tables or the whole Namespace
- Shows PID (ProcessID) from each Query Analyzer connection
- Shows Processlist
- Shows SELECT-Statements from SQL Views
- Show Routines

System requirements:
-

Enhancements
- Global Viewer is now working. Please attention about the global size, currently there is no limit!
- The Table-Viewer have now more filter functions from the context menu (look at the Data Panel and use right click on table).
- Faster startup.

FmPro Worksheet - A free graphical utility for sending SQL commands to FileMaker 7/8 databases. FmPro Worksheet enables FileMaker 7/8 database developers to use libraries of SQL commands to speed development of FileMaker 7/8 solutions. FileMaker 7/8 developers can utilize all SQL commands supported by the FileMaker 7/8 database including CREATE TABLE, DROP TABLE, SELECT, INSERT, UPDATE and DELETE. FmPro Worksheet is available for MacOS X and Windows, and may be downloaded from: http://www.fmpromigrator.com/downloads/demo_software/index.html#download_fmpro_worksheet
Enhancements:
- Added new Batch Load & Execute feature.
- This feature loads and executes all of the .sql files located within a folder selected by the user.

Requirements:
Lasso Web Data Engine 3.6.5 or later.

FileMaker Developer 6 is the tool of choice for creating custom FileMaker solutions for deployment across workgroups, distribution as royalty-free runtime applications, or sharing on the Web. Along with the benefits of FileMaker Pro 6, FileMaker Developer 6 includes updated time-saving development tools

Test and verify your scripts steps with the Script Debugger. Document the schema of your FileMaker solutions with the Database Design Report.

Use the Developer Tool to protect your solutions from modification and limit user controls, or to deploy your solutions in Kiosk mode or as a stand-alone application.

Whether you are developing commercial or corporate solutions, FileMaker Developer 6 is the indispensable tool for creating, customizing and deploying FileMaker solutions.

T-SQL Language Module For TextWrangler enables syntax coloring for the SQL scripts in TextWrangler.